{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# users\n",
    "uid=[]\n",
    "avatar=[]\n",
    "username=[]\n",
    "nickname=[]\n",
    "follows=[]\n",
    "fans=[]\n",
    "up_introduction=[]\n",
    "\n",
    "#video\n",
    "# uid[]\n",
    "img=[]\n",
    "bid=[]\n",
    "title=[]\n",
    "views=[]\n",
    "likes=[]\n",
    "coins=[]\n",
    "stars=[]\n",
    "shares=[]\n",
    "introduction=[]\n",
    "# comment\n",
    "# bid[]\n",
    "# uid[]\n",
    "talk=[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "import json\n",
    "url=['https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=3&fetch_row=10&fresh_idx=3&brush=3&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=9b8e066ee61435c8257739fabc48af8e&wts=1680226719',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=1&fetch_row=4&fresh_idx=1&brush=1&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=56a9e7617810458a064eecfc915d1e7b&wts=1680224392',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=2&fetch_row=7&fresh_idx=2&brush=2&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=8f078e02d47434d291dcacab1876236e&wts=1680226718',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=1&fetch_row=4&fresh_idx=1&brush=1&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=0fad9fd76081bd8c8b8bf2baa10c9c2c&wts=1680226717',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=4&fetch_row=13&fresh_idx=4&brush=4&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=36096f5433e039a7a7e0f340447ce8b9&wts=1680226905',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=1&fetch_row=4&fresh_idx=1&brush=1&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=ae8421e3afd18b1102204747b25017f8&wts=1680251912',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=2&fetch_row=7&fresh_idx=2&brush=2&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=f42a3523dbe7377bf2ad258598283b34&wts=1680251912',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=3&fetch_row=10&fresh_idx=3&brush=3&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=b8ca9f991688c2075b804b15357e48bd&wts=1680251976',\n",
    "     'https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=4&fetch_row=13&fresh_idx=4&brush=4&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=735d595cbce73e3b24221c63af66b30a&wts=1680252010'\n",
    "    ]\n",
    "r=requests.get(url[-1])\n",
    "r=json.loads(r.text)\n",
    "data=r['data']['item']\n",
    "len(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'id': 526768313,\n",
       " 'bvid': 'BV1sM411M7tq',\n",
       " 'cid': 1075955026,\n",
       " 'goto': 'av',\n",
       " 'uri': 'https://www.bilibili.com/video/BV1sM411M7tq',\n",
       " 'pic': 'http://i0.hdslb.com/bfs/archive/7b683520213796bac63328b93bb54e25ed5d30a3.jpg',\n",
       " 'title': '七年以来第二次大战，小咪败～',\n",
       " 'duration': 94,\n",
       " 'pubdate': 1680146255,\n",
       " 'owner': {'mid': 96109598,\n",
       "  'name': '好多喵meow',\n",
       "  'face': 'https://i2.hdslb.com/bfs/face/3e2466386a2a78f3afb3f2b8befdd36bbe2a73b3.jpg'},\n",
       " 'stat': {'view': 194278, 'like': 22492, 'danmaku': 240},\n",
       " 'av_feature': None,\n",
       " 'is_followed': 0,\n",
       " 'rcmd_reason': None,\n",
       " 'show_info': 0,\n",
       " 'track_id': '',\n",
       " 'pos': 0,\n",
       " 'room_info': None,\n",
       " 'ogv_info': None,\n",
       " 'business_info': None,\n",
       " 'is_stock': 0}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=3&fetch_row=10&fresh_idx=3&brush=3&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=9b8e066ee61435c8257739fabc48af8e&wts=1680226719\n",
      "让我给猜着了哈哈哈[doge][doge]\n",
      "看到这句话瞬间就要憋不住眼泪了。。。(;´༎ຶД༎ຶ`)\n",
      "左边我家那个二货拍的，把我拍的像个进击的巨人。[微笑]右边是路上找了个漂亮的小姐姐照的，人家随手一拍。\n",
      "你要去哪啊我说\n",
      "实际上，她不是把它当自己的孩子，而是把它当你的孩子养了[笑哭]\n",
      "00:31 眼镜姐姐好撩[喜欢]\n",
      "希望大家不要因为媒体宣传就去胖东来，把它当做景点去逛，绝对会失望的。这就是个超市，不是天堂\n",
      "这才是真正的电竞椅[脱单doge]\n",
      "老虎掏相机把人照的浑身麻痹，无法动弹。这个反转要笑死我了[笑哭][笑哭]\n",
      "up剪辑完这个视频 回想起当年在学校打篮球的日子，对面有个同学 他运球很快，我盯着球看，被他晃晕了~\n",
      "黑子当道，再无大同，那才是真正的不顺我心[给心心]\n",
      "我的超重通关呢！我的超重通关呢！我的超重通关呢！\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=1&fetch_row=4&fresh_idx=1&brush=1&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=56a9e7617810458a064eecfc915d1e7b&wts=1680224392\n",
      "献血对献血者不功不过，但是站在病人角度，无偿献血是规范渠道，政府监督下的可靠血液。所以，对病人是有利的，（反驳我的都是你对，古龙都同意你）\n",
      "另一方面无偿献血政策，针对的是有偿贩卖血液的黑色、灰色产业，如果病人用钱买都买不到正常人的无病毒血液，那是什么样的世界（海地？）（反驳我的还是你对，杜瓦利埃支持你）\n",
      "八年前刚上高中时舅舅送给我的一台佳能600D加一颗18-55镜头一直陪着我走到了现在。虽然她的对焦很难用，暗光下噪点爆炸，也没法拍视频，但不影响我爱她拍出来的照片。八年间用她记录下的点点滴滴已经成了我记忆中不可磨灭的部分。无数次想换性能参数更好的相机和镜头，但脑中一直铭记这大学摄影课老师说的“相机后面的那颗头才是最重要的”，便想着等到我真的能把这台相机的性能用到瓶颈的时候，自然就会买新的相机了。 我不知道这台相机还能继续陪伴我多久，但我会一直用她记录我的生活\n",
      "喜欢改前的朋友，大概是中意那种挂在墙上的版画浮世绘的韵味，回味很好。但是改之后是那种能在网页上一跳出来就抓住人的眼球，完全离不开，忍不住点进去点赞的感觉，在这种快节奏的时代，第一眼能快速的抓取人的视线，可能就是所谓的专业感本身[tv_冷漠]\n",
      "其实这个游戏最让我震惊的，是在巨大文化差异之下，制作组依然能够做出这么一款基于中华文化并且将中华“德”的文化深入理解并阐发的游戏。古语就有“君子以厚德载物的说法”，苏轼也曾说“以至诚为道，以至仁为德”。无论是武德结局，还是达成武德结局过程中的那五个字“仁尊义智诚”，都是对于中华“德”文化的完美阐述。单纯放下仇恨去宽恕，这不能称之为德。而做到了“仁尊义智诚”五点，立德立功立言立身，方能称之为德。这也是中国古代对于君子的要求\n",
      "虽然就是大部分人肯定都不能完整的看完，但是我还是很敬佩up主，本可以两分钟的鬼畜发几十段多恰点流量和玛尼，却选择了做了一个半小时的长鬼畜视频，这在现在短视频流行的当下都是很难得的，而且想必三个月坚持去做这一个视频也是需要情怀和毅力的，希望up坚持下去！三连已给！\n",
      "服务社是真的贴心，我到冬季拉练之前才发现，我们这个没女兵的营区里服务社会在拉练前卖卫生巾，一人买一包垫在鞋里脚不疼。\n",
      "真的很喜欢这个UP，这是我见过说中文最好的日本UP，秋雨加油，有机会来中国玩\n",
      "我也订了回国机票了，可是我妈妈生病了我怕她等不及我回去。祝你在家度过愉快时光\n",
      "奶牛猫，一种把白毛粘在黑衣服上，把黑毛粘在白衣服上的生物\n",
      "蓝色是虚无，紫色是沉默，黄色发给我\n",
      "Ai:七七小朋友，我和你一样也还是小孩子\n",
      "好有活力，这就是！\n",
      "\n",
      "疯狂星期四吧\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=2&fetch_row=7&fresh_idx=2&brush=2&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=8f078e02d47434d291dcacab1876236e&wts=1680226718\n",
      "快乐最重要了[保卫萝卜_哇]\n",
      "我永远喜欢这种建立在绝对实力的基础上的舞台的松弛感，这是我在绝大多数工业化女团成员身上见不到的，拿着手麦就敢把舞台当成玩儿一样，全身心地享受舞台，那种足以感染他人的活力、热情、热爱、快乐是粉丝最愿意看到的，妈妈木之后我再也没见过了。\n",
      "现在的电影都靠营销，以前的电影都靠质量[笑哭]\n",
      "给观众整个活 X\n",
      "给龙蜥整个活 ✓\n",
      "正在尝试一种新的翻唱视频形式，这样之后也可以经常去尝试录一些自己喜欢的歌！大家有没有想听我翻唱的歌[保卫萝卜_哇]\n",
      "兄弟们我是第一个鬼面，今天看到自己上电视了。我鬼面刚玩第二局。新手玩家。给我气坏了。最后还是杀了一个。兄弟们顶我上去。\n",
      "这根本不是男生减速带，是中国人民减速带！！！\n",
      "《源计划狼人》\n",
      "注：高清一图流请移步公众号\n",
      "\n",
      "00:11 阵容组成\n",
      "1.无转\n",
      "有源计划转凑6源计划，阵容强度会更高\n",
      "\n",
      "00:28 装备\n",
      "\n",
      "01:09 站位...\n",
      "配艾丽妮的头和语音会觉得可爱，用极境的可能就只剩生草了[doge]\n",
      "其实，小潮团队不止三个人，还有羊头人、小砍、李氏、小狼、小杨、背包、彩虹人等成员，只不过表面就小傲、高斯、海皇三个人,羊头人是负责拍摄，小砍死了（开玩笑的）小杨在外国留学，而小狼、李氏、背包负责我的世界游戏场地制作\n",
      "可不可以出一期限时捡废品（瓶子纸板之类的）然后卖钱，用卖的钱挑战食物[星星眼]\n",
      "UP的手工能力太强啦！我以后埋的时候肯定找你做设计！\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=1&fetch_row=4&fresh_idx=1&brush=1&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=0fad9fd76081bd8c8b8bf2baa10c9c2c&wts=1680226717\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=4&fetch_row=13&fresh_idx=4&brush=4&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=36096f5433e039a7a7e0f340447ce8b9&wts=1680226905\n",
      "小咪别怕哥来了！\n",
      "但使卖部贤王在，不叫贱龙进我村[崩坏3_乆][崩坏3_乆][崩坏3_乆]\n",
      "潘森拿出了mp3:哦哦哦哦哦哦哦哦哦哦哦哦哦[doge]\n",
      "女孩是比男孩成熟的早，俩姐弟其实年龄差距并不太大，一个在化妆已经在规划未来结婚对象了，另一个抱着一条带鱼在那吹泡泡[捂脸]\n",
      "给你们康康我上班厂门口的映山红\n",
      "虽然它丑，但是和爱[doge]\n",
      "说工地上挖那些千万别收，当初南水北调时候挖到我家附近，有工人说挖出一个九龙壁，我爹砍了半天价40抱回来了，结果是塑料填水泥的哈哈哈\n",
      "想到郭老师的:“对泰坦尼克号上的人来说是灾难，但是对厨房里的龙虾来说那就是生命的奇迹。”[doge]\n",
      "说不定树看见up时是这么想的！\n",
      "\"我抬头仰望苍穹的碧蓝，而低头俯看野草的油绿，当我享受着朝阳的庇护时，一个少年缓缓走上前来，与我谈起孤独，而我与其畅谈自由，他眼眸里含着我向往的朝暮，手掌中握着未来的希望，脚底下踏着如画般的风景，少年啊少年，美好的远方有许许多多棵树，有恒河沙数的人，也有无数次与山阁琼景遇见的机会，所以别把孤独雕刻在躯壳里，躯壳里应该满怀期待和风景。\"\n",
      "不好意思捏，比up的文笔差多了[保卫萝卜_哭哭]\n",
      "知道你们想要什么，帅帅安安\n",
      "如果没有朋友和你一起玩我的世界不妨来我最近新开的服务器试试！🐧裙号：740606046 进服教程在群文件里都有 手机电脑都可以进哦！ 服务器我会尽自己全力去运营，但可能也会有一些不足的地方，还请大家多多包容[打call]\n",
      "钟仁认证dance line！嘿嘿嘿\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=1&fetch_row=4&fresh_idx=1&brush=1&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=ae8421e3afd18b1102204747b25017f8&wts=1680251912\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=2&fetch_row=7&fresh_idx=2&brush=2&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=f42a3523dbe7377bf2ad258598283b34&wts=1680251912\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=3&fetch_row=10&fresh_idx=3&brush=3&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=b8ca9f991688c2075b804b15357e48bd&wts=1680251976\n",
      "https://api.bilibili.com/x/web-interface/wbi/index/top/feed/rcmd?y_num=3&fresh_type=4&feed_version=V8&fresh_idx_1h=4&fetch_row=13&fresh_idx=4&brush=4&homepage_ver=1&ps=12&last_y_num=4&outside_trigger=&w_rid=735d595cbce73e3b24221c63af66b30a&wts=1680252010\n"
     ]
    }
   ],
   "source": [
    "bid_uniqe=[]\n",
    "\n",
    "for i in range(len(url)):\n",
    "    print(url[i])\n",
    "    r=requests.get(url[i])\n",
    "    r=json.loads(r.text)\n",
    "    data=r['data']['item']\n",
    "    for j in range(len(data)):\n",
    "        if (not data[j]['cid'] in bid_uniqe):\n",
    "            bid_uniqe.append(data[j]['cid'])          \n",
    "            bid.append(data[j]['cid'])\n",
    "            uid.append(data[j]['owner']['mid'])\n",
    "            avatar.append(data[j]['owner']['face'])\n",
    "            nickname.append(data[j]['owner']['name'])\n",
    "            username.append('用户'+str(data[j]['owner']['mid']))\n",
    "            img.append(data[j]['pic'])\n",
    "            title.append(data[j]['title'])\n",
    "            views.append(data[j]['stat']['view'])\n",
    "            likes.append(data[j]['stat']['like'])\n",
    "            stars.append(data[j]['stat']['danmaku'])\n",
    "            #访问视频页\n",
    "            video_url='https://api.bilibili.com/x/web-interface/view/detail?platform=web&bvid='+str(data[j]['bvid'])+'&aid='+str(data[j]['cid'])+'&need_operation_card=1&web_rm_repeat=1&need_elec=1&out_referer=&page_no=1&p=1'\n",
    "            r=requests.get(video_url)\n",
    "            r=json.loads(r.text)\n",
    "            coins.append(r['data']['View']['stat']['coin'])\n",
    "            shares.append(r['data']['View']['stat']['share'])\n",
    "            introduction.append(r['data']['View']['desc'])\n",
    "\n",
    "            # 判断是否有评论\n",
    "            comment_url='https://api.bilibili.com/x/v2/reply/main?csrf=aa804a0faa243227b8f5e003a1762d96&mode=3&next=0&oid='+str(data[j]['id'])+'&plat=1&seek_rpid=&type=1'\n",
    "            r=requests.get(comment_url)\n",
    "            r=json.loads(r.text)\n",
    "            if(r['data']['replies']):\n",
    "                talk.append(r['data']['replies'][0]['content']['message'])\n",
    "                print(r['data']['replies'][0]['content']['message'])\n",
    "            else:\n",
    "                talk.append('')\n",
    "            # 访问用户主页"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "48"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(uid)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.chrome.service import Service\n",
    "from selenium.webdriver.common.by import By"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-7-5e6a2c884357>:1: DeprecationWarning: executable_path has been deprecated, please pass in a Service object\n",
      "  driver=webdriver.Chrome('E:\\chromedriver\\chromedriver.exe')\n"
     ]
    }
   ],
   "source": [
    "driver=webdriver.Chrome('E:\\chromedriver\\chromedriver.exe')\n",
    "user_url='https://space.bilibili.com/'+str(uid[0])\n",
    "driver.get(user_url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "def changeNum(numstr):\n",
    "    index=numstr.find('万')\n",
    "    if(index==-1):\n",
    "        return numstr\n",
    "    else:\n",
    "        numArr=re.findall('\\d+', numstr)\n",
    "        if(len(numArr)==1):\n",
    "            return str(int(numArr[0])*10000)\n",
    "        else:\n",
    "            return str(int(numArr[0])*10000+int(numArr[1])*1000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://space.bilibili.com/676128647\n",
      "https://space.bilibili.com/489010625\n",
      "https://space.bilibili.com/535019206\n",
      "https://space.bilibili.com/6054967\n",
      "https://space.bilibili.com/498873141\n",
      "https://space.bilibili.com/9094311\n",
      "https://space.bilibili.com/107486042\n",
      "https://space.bilibili.com/1577804\n",
      "https://space.bilibili.com/21979556\n",
      "https://space.bilibili.com/80304\n",
      "https://space.bilibili.com/7946432\n",
      "https://space.bilibili.com/29233734\n",
      "https://space.bilibili.com/208130286\n",
      "https://space.bilibili.com/946974\n",
      "https://space.bilibili.com/1688563568\n",
      "https://space.bilibili.com/28266043\n",
      "https://space.bilibili.com/527277977\n",
      "https://space.bilibili.com/473500781\n",
      "https://space.bilibili.com/1956887620\n",
      "https://space.bilibili.com/35539283\n",
      "https://space.bilibili.com/508416316\n",
      "https://space.bilibili.com/441833336\n",
      "https://space.bilibili.com/391636983\n",
      "https://space.bilibili.com/434476793\n",
      "https://space.bilibili.com/415403269\n",
      "https://space.bilibili.com/16720403\n",
      "https://space.bilibili.com/56345895\n",
      "https://space.bilibili.com/17603188\n",
      "https://space.bilibili.com/11253297\n",
      "https://space.bilibili.com/946324\n",
      "https://space.bilibili.com/1979774677\n",
      "https://space.bilibili.com/18343134\n",
      "https://space.bilibili.com/190952664\n",
      "https://space.bilibili.com/434157581\n",
      "https://space.bilibili.com/54911793\n",
      "https://space.bilibili.com/452060800\n",
      "https://space.bilibili.com/96109598\n",
      "https://space.bilibili.com/3461565017754459\n",
      "https://space.bilibili.com/521686097\n",
      "https://space.bilibili.com/323024456\n",
      "https://space.bilibili.com/90142376\n",
      "https://space.bilibili.com/1850119898\n",
      "https://space.bilibili.com/11083481\n",
      "https://space.bilibili.com/1925825358\n",
      "https://space.bilibili.com/1474965865\n",
      "https://space.bilibili.com/400667244\n",
      "https://space.bilibili.com/1076872109\n",
      "https://space.bilibili.com/162151104\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(uid)):\n",
    "    user_url='https://space.bilibili.com/'+str(uid[i])\n",
    "    print(user_url)\n",
    "    driver.get(user_url)\n",
    "    temp=driver.find_elements(By.XPATH,'//*[@id=\"n-gz\"]')\n",
    "    if(temp):\n",
    "        follows.append(temp[0].text)\n",
    "    else:\n",
    "        follows.append(0)\n",
    "\n",
    "    temp=driver.find_elements(By.XPATH,'//*[@id=\"n-fs\"]')\n",
    "    if(temp):\n",
    "        fans.append(changeNum(temp[0].text))\n",
    "    else:\n",
    "        fans.append(0)    \n",
    "    temp=driver.find_elements(By.XPATH,'//*[@id=\"app\"]/div[1]/div[1]/div[2]/div[2]/div/div[2]/div[2]/h4')\n",
    "    if(temp):\n",
    "        up_introduction.append(temp[0].text)\n",
    "    else:\n",
    "        up_introduction.append('')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n",
      "48\n"
     ]
    }
   ],
   "source": [
    "print(len(uid))\n",
    "print(len(avatar))\n",
    "print(len(username))\n",
    "print(len(nickname))\n",
    "print(len(follows))\n",
    "print(len(fans))\n",
    "print(len(up_introduction))\n",
    "print(len(img))\n",
    "print(len(bid))\n",
    "print(len(title))\n",
    "print(len(views))\n",
    "print(len(likes))\n",
    "print(len(coins))\n",
    "print(len(stars))\n",
    "print(len(shares))\n",
    "print(len(introduction))\n",
    "print(len(talk))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 创建评论的user_id 虚拟数据\n",
    "comment_user_id=[]\n",
    "comment_user_id=uid.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "comment_user_id.append(comment_user_id.pop(0))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[489010625,\n",
       " 535019206,\n",
       " 6054967,\n",
       " 498873141,\n",
       " 9094311,\n",
       " 107486042,\n",
       " 1577804,\n",
       " 21979556,\n",
       " 80304,\n",
       " 7946432,\n",
       " 29233734,\n",
       " 208130286,\n",
       " 946974,\n",
       " 1688563568,\n",
       " 28266043,\n",
       " 527277977,\n",
       " 473500781,\n",
       " 1956887620,\n",
       " 35539283,\n",
       " 508416316,\n",
       " 441833336,\n",
       " 391636983,\n",
       " 434476793,\n",
       " 415403269,\n",
       " 16720403,\n",
       " 56345895,\n",
       " 17603188,\n",
       " 11253297,\n",
       " 946324,\n",
       " 1979774677,\n",
       " 18343134,\n",
       " 190952664,\n",
       " 434157581,\n",
       " 54911793,\n",
       " 452060800,\n",
       " 96109598,\n",
       " 3461565017754459,\n",
       " 521686097,\n",
       " 323024456,\n",
       " 90142376,\n",
       " 1850119898,\n",
       " 11083481,\n",
       " 1925825358,\n",
       " 1474965865,\n",
       " 400667244,\n",
       " 1076872109,\n",
       " 162151104,\n",
       " 676128647]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comment_user_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pymysql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "comment_data=[]\n",
    "for i in range(len(uid)):\n",
    "    temp=(bid[i],comment_user_id[i],talk[i])\n",
    "    comment_data.append(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(1075001008, 489010625, '让我给猜着了哈哈哈[doge][doge]'),\n",
       " (1076767277, 535019206, '看到这句话瞬间就要憋不住眼泪了。。。(;´༎ຶД༎ຶ`)'),\n",
       " (1075444862, 6054967, '左边我家那个二货拍的，把我拍的像个进击的巨人。[微笑]右边是路上找了个漂亮的小姐姐照的，人家随手一拍。'),\n",
       " (1071720679, 498873141, '你要去哪啊我说'),\n",
       " (1075857253, 9094311, '实际上，她不是把它当自己的孩子，而是把它当你的孩子养了[笑哭]'),\n",
       " (1075324153, 107486042, '00:31 眼镜姐姐好撩[喜欢]'),\n",
       " (1072653268, 1577804, '希望大家不要因为媒体宣传就去胖东来，把它当做景点去逛，绝对会失望的。这就是个超市，不是天堂'),\n",
       " (1073696607, 21979556, '这才是真正的电竞椅[脱单doge]'),\n",
       " (1069179218, 80304, '老虎掏相机把人照的浑身麻痹，无法动弹。这个反转要笑死我了[笑哭][笑哭]'),\n",
       " (1076409266, 7946432, 'up剪辑完这个视频 回想起当年在学校打篮球的日子，对面有个同学 他运球很快，我盯着球看，被他晃晕了~'),\n",
       " (1076800474, 29233734, '黑子当道，再无大同，那才是真正的不顺我心[给心心]'),\n",
       " (1077032587, 208130286, '我的超重通关呢！我的超重通关呢！我的超重通关呢！'),\n",
       " (1074409876,\n",
       "  946974,\n",
       "  '献血对献血者不功不过，但是站在病人角度，无偿献血是规范渠道，政府监督下的可靠血液。所以，对病人是有利的，（反驳我的都是你对，古龙都同意你）\\n另一方面无偿献血政策，针对的是有偿贩卖血液的黑色、灰色产业，如果病人用钱买都买不到正常人的无病毒血液，那是什么样的世界（海地？）（反驳我的还是你对，杜瓦利埃支持你）'),\n",
       " (1073086589,\n",
       "  1688563568,\n",
       "  '八年前刚上高中时舅舅送给我的一台佳能600D加一颗18-55镜头一直陪着我走到了现在。虽然她的对焦很难用，暗光下噪点爆炸，也没法拍视频，但不影响我爱她拍出来的照片。八年间用她记录下的点点滴滴已经成了我记忆中不可磨灭的部分。无数次想换性能参数更好的相机和镜头，但脑中一直铭记这大学摄影课老师说的“相机后面的那颗头才是最重要的”，便想着等到我真的能把这台相机的性能用到瓶颈的时候，自然就会买新的相机了。 我不知道这台相机还能继续陪伴我多久，但我会一直用她记录我的生活'),\n",
       " (1076726002,\n",
       "  28266043,\n",
       "  '喜欢改前的朋友，大概是中意那种挂在墙上的版画浮世绘的韵味，回味很好。但是改之后是那种能在网页上一跳出来就抓住人的眼球，完全离不开，忍不住点进去点赞的感觉，在这种快节奏的时代，第一眼能快速的抓取人的视线，可能就是所谓的专业感本身[tv_冷漠]'),\n",
       " (1074286238,\n",
       "  527277977,\n",
       "  '其实这个游戏最让我震惊的，是在巨大文化差异之下，制作组依然能够做出这么一款基于中华文化并且将中华“德”的文化深入理解并阐发的游戏。古语就有“君子以厚德载物的说法”，苏轼也曾说“以至诚为道，以至仁为德”。无论是武德结局，还是达成武德结局过程中的那五个字“仁尊义智诚”，都是对于中华“德”文化的完美阐述。单纯放下仇恨去宽恕，这不能称之为德。而做到了“仁尊义智诚”五点，立德立功立言立身，方能称之为德。这也是中国古代对于君子的要求'),\n",
       " (1071272790,\n",
       "  473500781,\n",
       "  '虽然就是大部分人肯定都不能完整的看完，但是我还是很敬佩up主，本可以两分钟的鬼畜发几十段多恰点流量和玛尼，却选择了做了一个半小时的长鬼畜视频，这在现在短视频流行的当下都是很难得的，而且想必三个月坚持去做这一个视频也是需要情怀和毅力的，希望up坚持下去！三连已给！'),\n",
       " (1076765438,\n",
       "  1956887620,\n",
       "  '服务社是真的贴心，我到冬季拉练之前才发现，我们这个没女兵的营区里服务社会在拉练前卖卫生巾，一人买一包垫在鞋里脚不疼。'),\n",
       " (1076854443, 35539283, '真的很喜欢这个UP，这是我见过说中文最好的日本UP，秋雨加油，有机会来中国玩'),\n",
       " (1075957789, 508416316, '我也订了回国机票了，可是我妈妈生病了我怕她等不及我回去。祝你在家度过愉快时光'),\n",
       " (1075454991, 441833336, '奶牛猫，一种把白毛粘在黑衣服上，把黑毛粘在白衣服上的生物'),\n",
       " (1069834414, 391636983, '蓝色是虚无，紫色是沉默，黄色发给我'),\n",
       " (1072594268, 434476793, 'Ai:七七小朋友，我和你一样也还是小孩子'),\n",
       " (1076855597, 415403269, '好有活力，这就是！\\n\\n疯狂星期四吧'),\n",
       " (1075016871, 16720403, '快乐最重要了[保卫萝卜_哇]'),\n",
       " (1076713183,\n",
       "  56345895,\n",
       "  '我永远喜欢这种建立在绝对实力的基础上的舞台的松弛感，这是我在绝大多数工业化女团成员身上见不到的，拿着手麦就敢把舞台当成玩儿一样，全身心地享受舞台，那种足以感染他人的活力、热情、热爱、快乐是粉丝最愿意看到的，妈妈木之后我再也没见过了。'),\n",
       " (1071642301, 17603188, '现在的电影都靠营销，以前的电影都靠质量[笑哭]'),\n",
       " (1076493184, 11253297, '给观众整个活 X\\n给龙蜥整个活 ✓'),\n",
       " (1070399105,\n",
       "  946324,\n",
       "  '正在尝试一种新的翻唱视频形式，这样之后也可以经常去尝试录一些自己喜欢的歌！大家有没有想听我翻唱的歌[保卫萝卜_哇]'),\n",
       " (1074741987,\n",
       "  1979774677,\n",
       "  '兄弟们我是第一个鬼面，今天看到自己上电视了。我鬼面刚玩第二局。新手玩家。给我气坏了。最后还是杀了一个。兄弟们顶我上去。'),\n",
       " (1068976758, 18343134, '这根本不是男生减速带，是中国人民减速带！！！'),\n",
       " (1075308912,\n",
       "  190952664,\n",
       "  '《源计划狼人》\\n注：高清一图流请移步公众号\\n\\n00:11 阵容组成\\n1.无转\\n有源计划转凑6源计划，阵容强度会更高\\n\\n00:28 装备\\n\\n01:09 站位...'),\n",
       " (1074896232, 434157581, '配艾丽妮的头和语音会觉得可爱，用极境的可能就只剩生草了[doge]'),\n",
       " (1074168145,\n",
       "  54911793,\n",
       "  '其实，小潮团队不止三个人，还有羊头人、小砍、李氏、小狼、小杨、背包、彩虹人等成员，只不过表面就小傲、高斯、海皇三个人,羊头人是负责拍摄，小砍死了（开玩笑的）小杨在外国留学，而小狼、李氏、背包负责我的世界游戏场地制作'),\n",
       " (1071738170, 452060800, '可不可以出一期限时捡废品（瓶子纸板之类的）然后卖钱，用卖的钱挑战食物[星星眼]'),\n",
       " (1072647882, 96109598, 'UP的手工能力太强啦！我以后埋的时候肯定找你做设计！'),\n",
       " (1075955026, 3461565017754459, '小咪别怕哥来了！'),\n",
       " (1075515223, 521686097, '但使卖部贤王在，不叫贱龙进我村[崩坏3_乆][崩坏3_乆][崩坏3_乆]'),\n",
       " (1068948883, 323024456, '潘森拿出了mp3:哦哦哦哦哦哦哦哦哦哦哦哦哦[doge]'),\n",
       " (1074209209,\n",
       "  90142376,\n",
       "  '女孩是比男孩成熟的早，俩姐弟其实年龄差距并不太大，一个在化妆已经在规划未来结婚对象了，另一个抱着一条带鱼在那吹泡泡[捂脸]'),\n",
       " (1073815725, 1850119898, '给你们康康我上班厂门口的映山红'),\n",
       " (1072081711, 11083481, '虽然它丑，但是和爱[doge]'),\n",
       " (1072938807,\n",
       "  1925825358,\n",
       "  '说工地上挖那些千万别收，当初南水北调时候挖到我家附近，有工人说挖出一个九龙壁，我爹砍了半天价40抱回来了，结果是塑料填水泥的哈哈哈'),\n",
       " (1075984023,\n",
       "  1474965865,\n",
       "  '想到郭老师的:“对泰坦尼克号上的人来说是灾难，但是对厨房里的龙虾来说那就是生命的奇迹。”[doge]'),\n",
       " (1069028813,\n",
       "  400667244,\n",
       "  '说不定树看见up时是这么想的！\\n\"我抬头仰望苍穹的碧蓝，而低头俯看野草的油绿，当我享受着朝阳的庇护时，一个少年缓缓走上前来，与我谈起孤独，而我与其畅谈自由，他眼眸里含着我向往的朝暮，手掌中握着未来的希望，脚底下踏着如画般的风景，少年啊少年，美好的远方有许许多多棵树，有恒河沙数的人，也有无数次与山阁琼景遇见的机会，所以别把孤独雕刻在躯壳里，躯壳里应该满怀期待和风景。\"\\n不好意思捏，比up的文笔差多了[保卫萝卜_哭哭]'),\n",
       " (1072886181, 1076872109, '知道你们想要什么，帅帅安安'),\n",
       " (1070912246,\n",
       "  162151104,\n",
       "  '如果没有朋友和你一起玩我的世界不妨来我最近新开的服务器试试！🐧裙号：740606046 进服教程在群文件里都有 手机电脑都可以进哦！ 服务器我会尽自己全力去运营，但可能也会有一些不足的地方，还请大家多多包容[打call]'),\n",
       " (1076166115, 676128647, '钟仁认证dance line！嘿嘿嘿')]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comment_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# db=pymysql.connect(host='localhost',\n",
    "#                    user='root',\n",
    "#                    password='123456',\n",
    "#                    database='bilibili')\n",
    "# cursor=db.cursor()\n",
    "# sql=\"insert into comment (video_id,user_id,talk) values (%s,%s,'%s')\"\n",
    "# try:\n",
    "#     cursor.executemany(sql,comment_data)\n",
    "#     db.commit()\n",
    "#     print('连接成功')\n",
    "# except:\n",
    "#     print('连接失败')\n",
    "#     db.rollback()\n",
    "# cursor.close()\n",
    "# db.close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "insert into comment (video_id,user_id,talk) values (1075001008,489010625,'让我给猜着了哈哈哈[doge][doge]');\n",
      "insert into comment (video_id,user_id,talk) values (1076767277,535019206,'看到这句话瞬间就要憋不住眼泪了。。。(;´༎ຶД༎ຶ`)');\n",
      "insert into comment (video_id,user_id,talk) values (1075444862,6054967,'左边我家那个二货拍的，把我拍的像个进击的巨人。[微笑]右边是路上找了个漂亮的小姐姐照的，人家随手一拍。');\n",
      "insert into comment (video_id,user_id,talk) values (1071720679,498873141,'你要去哪啊我说');\n",
      "insert into comment (video_id,user_id,talk) values (1075857253,9094311,'实际上，她不是把它当自己的孩子，而是把它当你的孩子养了[笑哭]');\n",
      "insert into comment (video_id,user_id,talk) values (1075324153,107486042,'00:31 眼镜姐姐好撩[喜欢]');\n",
      "insert into comment (video_id,user_id,talk) values (1072653268,1577804,'希望大家不要因为媒体宣传就去胖东来，把它当做景点去逛，绝对会失望的。这就是个超市，不是天堂');\n",
      "insert into comment (video_id,user_id,talk) values (1073696607,21979556,'这才是真正的电竞椅[脱单doge]');\n",
      "insert into comment (video_id,user_id,talk) values (1069179218,80304,'老虎掏相机把人照的浑身麻痹，无法动弹。这个反转要笑死我了[笑哭][笑哭]');\n",
      "insert into comment (video_id,user_id,talk) values (1076409266,7946432,'up剪辑完这个视频 回想起当年在学校打篮球的日子，对面有个同学 他运球很快，我盯着球看，被他晃晕了~');\n",
      "insert into comment (video_id,user_id,talk) values (1076800474,29233734,'黑子当道，再无大同，那才是真正的不顺我心[给心心]');\n",
      "insert into comment (video_id,user_id,talk) values (1077032587,208130286,'我的超重通关呢！我的超重通关呢！我的超重通关呢！');\n",
      "insert into comment (video_id,user_id,talk) values (1074409876,946974,'献血对献血者不功不过，但是站在病人角度，无偿献血是规范渠道，政府监督下的可靠血液。所以，对病人是有利的，（反驳我的都是你对，古龙都同意你）\n",
      "另一方面无偿献血政策，针对的是有偿贩卖血液的黑色、灰色产业，如果病人用钱买都买不到正常人的无病毒血液，那是什么样的世界（海地？）（反驳我的还是你对，杜瓦利埃支持你）');\n",
      "insert into comment (video_id,user_id,talk) values (1073086589,1688563568,'八年前刚上高中时舅舅送给我的一台佳能600D加一颗18-55镜头一直陪着我走到了现在。虽然她的对焦很难用，暗光下噪点爆炸，也没法拍视频，但不影响我爱她拍出来的照片。八年间用她记录下的点点滴滴已经成了我记忆中不可磨灭的部分。无数次想换性能参数更好的相机和镜头，但脑中一直铭记这大学摄影课老师说的“相机后面的那颗头才是最重要的”，便想着等到我真的能把这台相机的性能用到瓶颈的时候，自然就会买新的相机了。 我不知道这台相机还能继续陪伴我多久，但我会一直用她记录我的生活');\n",
      "insert into comment (video_id,user_id,talk) values (1076726002,28266043,'喜欢改前的朋友，大概是中意那种挂在墙上的版画浮世绘的韵味，回味很好。但是改之后是那种能在网页上一跳出来就抓住人的眼球，完全离不开，忍不住点进去点赞的感觉，在这种快节奏的时代，第一眼能快速的抓取人的视线，可能就是所谓的专业感本身[tv_冷漠]');\n",
      "insert into comment (video_id,user_id,talk) values (1074286238,527277977,'其实这个游戏最让我震惊的，是在巨大文化差异之下，制作组依然能够做出这么一款基于中华文化并且将中华“德”的文化深入理解并阐发的游戏。古语就有“君子以厚德载物的说法”，苏轼也曾说“以至诚为道，以至仁为德”。无论是武德结局，还是达成武德结局过程中的那五个字“仁尊义智诚”，都是对于中华“德”文化的完美阐述。单纯放下仇恨去宽恕，这不能称之为德。而做到了“仁尊义智诚”五点，立德立功立言立身，方能称之为德。这也是中国古代对于君子的要求');\n",
      "insert into comment (video_id,user_id,talk) values (1071272790,473500781,'虽然就是大部分人肯定都不能完整的看完，但是我还是很敬佩up主，本可以两分钟的鬼畜发几十段多恰点流量和玛尼，却选择了做了一个半小时的长鬼畜视频，这在现在短视频流行的当下都是很难得的，而且想必三个月坚持去做这一个视频也是需要情怀和毅力的，希望up坚持下去！三连已给！');\n",
      "insert into comment (video_id,user_id,talk) values (1076765438,1956887620,'服务社是真的贴心，我到冬季拉练之前才发现，我们这个没女兵的营区里服务社会在拉练前卖卫生巾，一人买一包垫在鞋里脚不疼。');\n",
      "insert into comment (video_id,user_id,talk) values (1076854443,35539283,'真的很喜欢这个UP，这是我见过说中文最好的日本UP，秋雨加油，有机会来中国玩');\n",
      "insert into comment (video_id,user_id,talk) values (1075957789,508416316,'我也订了回国机票了，可是我妈妈生病了我怕她等不及我回去。祝你在家度过愉快时光');\n",
      "insert into comment (video_id,user_id,talk) values (1075454991,441833336,'奶牛猫，一种把白毛粘在黑衣服上，把黑毛粘在白衣服上的生物');\n",
      "insert into comment (video_id,user_id,talk) values (1069834414,391636983,'蓝色是虚无，紫色是沉默，黄色发给我');\n",
      "insert into comment (video_id,user_id,talk) values (1072594268,434476793,'Ai:七七小朋友，我和你一样也还是小孩子');\n",
      "insert into comment (video_id,user_id,talk) values (1076855597,415403269,'好有活力，这就是！\n",
      "\n",
      "疯狂星期四吧');\n",
      "insert into comment (video_id,user_id,talk) values (1075016871,16720403,'快乐最重要了[保卫萝卜_哇]');\n",
      "insert into comment (video_id,user_id,talk) values (1076713183,56345895,'我永远喜欢这种建立在绝对实力的基础上的舞台的松弛感，这是我在绝大多数工业化女团成员身上见不到的，拿着手麦就敢把舞台当成玩儿一样，全身心地享受舞台，那种足以感染他人的活力、热情、热爱、快乐是粉丝最愿意看到的，妈妈木之后我再也没见过了。');\n",
      "insert into comment (video_id,user_id,talk) values (1071642301,17603188,'现在的电影都靠营销，以前的电影都靠质量[笑哭]');\n",
      "insert into comment (video_id,user_id,talk) values (1076493184,11253297,'给观众整个活 X\n",
      "给龙蜥整个活 ✓');\n",
      "insert into comment (video_id,user_id,talk) values (1070399105,946324,'正在尝试一种新的翻唱视频形式，这样之后也可以经常去尝试录一些自己喜欢的歌！大家有没有想听我翻唱的歌[保卫萝卜_哇]');\n",
      "insert into comment (video_id,user_id,talk) values (1074741987,1979774677,'兄弟们我是第一个鬼面，今天看到自己上电视了。我鬼面刚玩第二局。新手玩家。给我气坏了。最后还是杀了一个。兄弟们顶我上去。');\n",
      "insert into comment (video_id,user_id,talk) values (1068976758,18343134,'这根本不是男生减速带，是中国人民减速带！！！');\n",
      "insert into comment (video_id,user_id,talk) values (1075308912,190952664,'《源计划狼人》\n",
      "注：高清一图流请移步公众号\n",
      "\n",
      "00:11 阵容组成\n",
      "1.无转\n",
      "有源计划转凑6源计划，阵容强度会更高\n",
      "\n",
      "00:28 装备\n",
      "\n",
      "01:09 站位...');\n",
      "insert into comment (video_id,user_id,talk) values (1074896232,434157581,'配艾丽妮的头和语音会觉得可爱，用极境的可能就只剩生草了[doge]');\n",
      "insert into comment (video_id,user_id,talk) values (1074168145,54911793,'其实，小潮团队不止三个人，还有羊头人、小砍、李氏、小狼、小杨、背包、彩虹人等成员，只不过表面就小傲、高斯、海皇三个人,羊头人是负责拍摄，小砍死了（开玩笑的）小杨在外国留学，而小狼、李氏、背包负责我的世界游戏场地制作');\n",
      "insert into comment (video_id,user_id,talk) values (1071738170,452060800,'可不可以出一期限时捡废品（瓶子纸板之类的）然后卖钱，用卖的钱挑战食物[星星眼]');\n",
      "insert into comment (video_id,user_id,talk) values (1072647882,96109598,'UP的手工能力太强啦！我以后埋的时候肯定找你做设计！');\n",
      "insert into comment (video_id,user_id,talk) values (1075955026,3461565017754459,'小咪别怕哥来了！');\n",
      "insert into comment (video_id,user_id,talk) values (1075515223,521686097,'但使卖部贤王在，不叫贱龙进我村[崩坏3_乆][崩坏3_乆][崩坏3_乆]');\n",
      "insert into comment (video_id,user_id,talk) values (1068948883,323024456,'潘森拿出了mp3:哦哦哦哦哦哦哦哦哦哦哦哦哦[doge]');\n",
      "insert into comment (video_id,user_id,talk) values (1074209209,90142376,'女孩是比男孩成熟的早，俩姐弟其实年龄差距并不太大，一个在化妆已经在规划未来结婚对象了，另一个抱着一条带鱼在那吹泡泡[捂脸]');\n",
      "insert into comment (video_id,user_id,talk) values (1073815725,1850119898,'给你们康康我上班厂门口的映山红');\n",
      "insert into comment (video_id,user_id,talk) values (1072081711,11083481,'虽然它丑，但是和爱[doge]');\n",
      "insert into comment (video_id,user_id,talk) values (1072938807,1925825358,'说工地上挖那些千万别收，当初南水北调时候挖到我家附近，有工人说挖出一个九龙壁，我爹砍了半天价40抱回来了，结果是塑料填水泥的哈哈哈');\n",
      "insert into comment (video_id,user_id,talk) values (1075984023,1474965865,'想到郭老师的:“对泰坦尼克号上的人来说是灾难，但是对厨房里的龙虾来说那就是生命的奇迹。”[doge]');\n",
      "insert into comment (video_id,user_id,talk) values (1069028813,400667244,'说不定树看见up时是这么想的！\n",
      "\"我抬头仰望苍穹的碧蓝，而低头俯看野草的油绿，当我享受着朝阳的庇护时，一个少年缓缓走上前来，与我谈起孤独，而我与其畅谈自由，他眼眸里含着我向往的朝暮，手掌中握着未来的希望，脚底下踏着如画般的风景，少年啊少年，美好的远方有许许多多棵树，有恒河沙数的人，也有无数次与山阁琼景遇见的机会，所以别把孤独雕刻在躯壳里，躯壳里应该满怀期待和风景。\"\n",
      "不好意思捏，比up的文笔差多了[保卫萝卜_哭哭]');\n",
      "insert into comment (video_id,user_id,talk) values (1072886181,1076872109,'知道你们想要什么，帅帅安安');\n",
      "insert into comment (video_id,user_id,talk) values (1070912246,162151104,'如果没有朋友和你一起玩我的世界不妨来我最近新开的服务器试试！🐧裙号：740606046 进服教程在群文件里都有 手机电脑都可以进哦！ 服务器我会尽自己全力去运营，但可能也会有一些不足的地方，还请大家多多包容[打call]');\n",
      "insert into comment (video_id,user_id,talk) values (1076166115,676128647,'钟仁认证dance line！嘿嘿嘿');\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(uid)):\n",
    "    \n",
    "    str_sql=\"insert into comment (video_id,user_id,talk) values (%s,%s,'%s');\"\n",
    "    print(str_sql%(comment_data[i][0],comment_data[i][1],comment_data[i][2]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "user_data=[]\n",
    "for i in range(len(uid)):\n",
    "    temp=(uid[i],username[i],nickname[i],avatar[i],follows[i],fans[i],up_introduction[i])\n",
    "    user_data.append(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (676128647,'用户676128647','张踩铃','https://i2.hdslb.com/bfs/face/fa750db805079995e7cead6a6490b41a7cd39e28.jpg','16','551000','唉？大家发现没？ 踩铃儿来B站开账号了！ 欢迎新老朋友捧场，陆续为大家更新作品');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (489010625,'用户489010625','奥特曼王国','https://i2.hdslb.com/bfs/face/3815e14df08d53b2ab33c97bf519736cb56ef129.jpg','20','39000','请不要在意我的名字……');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (535019206,'用户535019206','人类行为图鉴V','http://i1.hdslb.com/bfs/face/555777fe4ec29bcf79bd91895874886b5d762d92.jpg','3','1792000','weibo：@人类行为图鉴');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (6054967,'用户6054967','茶咩cc','https://i1.hdslb.com/bfs/face/683be52952965bc67fdf1fc19d93ad8e23549da8.jpg','159','323000','要天天开心哦～丨无粉丝群丨商务合作qq：873411793（非本人），不接受其他平台入驻哦～');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (498873141,'用户498873141','小憩喵喵君','https://i0.hdslb.com/bfs/face/118a53904fe35a2fb3be79e4f51bbec896241fda.png','22','9571','分享各色故事，品百味人间！谢谢朋友你的支持与信任！QQ群：535018298');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (9094311,'用户9094311','临时工小陈','https://i0.hdslb.com/bfs/face/d60718e33c0e0eb42d07d88ba8eb09b9f3fcabdf.jpg','150','263000','我司不定期招聘老板，待遇从优 商务请联系：Fadachai-here 大柴工作室出品');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (107486042,'用户107486042','花二Strange','https://i2.hdslb.com/bfs/face/20ba5c558b6fece1b9cb1bb8697e18f84c9c11f5.jpg','309','1365000','商务合作请私信或者邮箱2576206748@qq.com');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1577804,'用户1577804','某幻君','https://i2.hdslb.com/bfs/face/a7eda2f97431d13f89a43b310262d1b19be83c01.jpg','62','7871000','有事私信新娘浪微博@某幻今天拖更了没');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (21979556,'用户21979556','你的硬币是我dio哒','https://i2.hdslb.com/bfs/face/5aaa6336c5277fb9bc893bc45281b053ee07221c.jpg','45','605000','关注第一时间看新活，商务合作QQ495858457 粉丝群 二群625400847');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (80304,'用户80304','亚食人','https://i0.hdslb.com/bfs/face/3f1496f48a5eb840a974fef0fd7db7a3f225fbe7.jpg','390','1372000','up臭打游戏的幕后工具人，配音@胀胀&撑撑，合作私信~');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (7946432,'用户7946432','利维坦mY','https://i2.hdslb.com/bfs/face/5c28c5428dbec662de927fc3fd8df74b2273df87.jpg','220','1020000','微博@利维坦mY 商务合作V信：levitan81（全小写）未加入任何MCN');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (29233734,'用户29233734','路可一下','https://i0.hdslb.com/bfs/face/506dadc2c06caca0db660228841dcdae039f0a45.jpg','116','40000','是一个一个一个臭打游戏的乐子人，油管频道：路可一下');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (208130286,'用户208130286','大物是也','http://i0.hdslb.com/bfs/face/8a01e29bab16f51fb9c322804b4bf2508c3edbfd.jpg','71','973000','微博：大物THU 欢迎大家关注～');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (946974,'用户946974','影视飓风','https://i0.hdslb.com/bfs/face/c1733474892caa45952b2c09a89323157df7129a.jpg','555','5792000','无限进步！微博@影视飓风MediaStorm｜商务合作请联系WX：ysjfBD（添加麻烦备注公司、咨询内容）');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1688563568,'用户1688563568','插画家斋藤直葵','https://i2.hdslb.com/bfs/face/b73daf360b7b7833d75fc51b2abd7e04be89a0fc.jpg','6','684000','斋藤直葵，日本插画家、漫画家。代表作：漫画《刃牙～豪仔～ 》、《宝可梦黑·白》形象插画等 商务加V：270003641（注明来意）');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (28266043,'用户28266043','附魔星Fms','https://i1.hdslb.com/bfs/face/e1e951eef95d0a88efbe746ac7a73570b29dc3d2.jpg','218','1279000','微博：附魔星星星 商务qq：327364388');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (527277977,'用户527277977','鬼畜狗熊岭','https://i2.hdslb.com/bfs/face/be89a9d73a32b010a4e97103bbaaf5ea24f0ef27.jpg','108','100000','水视频的屑阿婆 ||腾龙Dragon鬼畜社社员||');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (473500781,'用户473500781','没有脖子的平远','https://i2.hdslb.com/bfs/face/e4272d84fc06ee3cb4c631f6fe12ea04f1a2ff96.jpg','96','371000','主业IT,副业衣服和酒。商微:xinsidang 某宝：Plantagenet洋服');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1956887620,'用户1956887620','秋雨在日本','https://i1.hdslb.com/bfs/face/b9f3a04d79551eb52fa61272883d5aa4b6139924.jpg','35','74000','建筑设计师，日本低端游路线规划师，优衣裤二级代言人，业余考研留学咨询顾问，情感咨询专家，社会心理学研究员');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (35539283,'用户35539283','Madge曼婕','http://i2.hdslb.com/bfs/face/dd06c64b2cfa76da6f518b4bb25847b3f21acc6f.jpg','14','83000','意大利餐厅工作的艺术学者');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (508416316,'用户508416316','本喵叫兔兔','https://i1.hdslb.com/bfs/face/dd3ca18b9504ea0db42655446efd533795811e17.jpg','90','2212000','猫德学院院长 流浪小奶猫的终结者 绑架团伙首要头目 领养V: DRH326349533 商务V:TT326349533（注明品牌）');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (441833336,'用户441833336','时空中的绘旅人','https://i2.hdslb.com/bfs/face/d9031b4b38e9de37efa8cd598c3007dce4efa32f.jpg','3','657000','命运牵引，启程向你。下载：https://b23.tv/BEO7tZ');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (391636983,'用户391636983','动漫跳舞姬','https://i0.hdslb.com/bfs/face/cd7609a3359dbc9d4f96d9ef7496f1ced9a2b34c.jpg','111','81000','传说中的巴掌up主（爱发电: https://afdian.net/a/dmtwj666） 励志让你们挨够999个老婆的巴掌');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (434476793,'用户434476793','优联酱uu','https://i2.hdslb.com/bfs/face/d12a24df8ef8b85e5a7ff4b5559695aab55224cb.jpg','368','146000','٩(๑^o^๑)۶ 是要好好学习多多请教的学生!! 微博同名 里面是碎碎念和一些图片 商务v：yurium000（注明来意）');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (415403269,'用户415403269','internet-boy','https://i1.hdslb.com/bfs/face/21455f5f8b4733b783b3f05d35af775608194d7c.jpg','2','1146000','微博：@internet-garcon-pdf');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (16720403,'用户16720403','pcyxjy','http://i2.hdslb.com/bfs/face/f4475f7a56a13d0553f471b0ae851fc14decb4d5.jpg','47','1565000','安利所有值得喜欢的ta们 合作请私信 谢谢小可爱的关注');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (56345895,'用户56345895','才疏学浅的糯米','http://i0.hdslb.com/bfs/face/2108780cedbf2f2bcd23d10541e84bd40bdecf4b.jpg','51','50000','原ID:不会混剪的糯米 商务合作请私信 表明来意');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (17603188,'用户17603188','雷雨Lyy','https://i1.hdslb.com/bfs/face/0edf7705e2384910a98c1fd1219225bf3ac80e0d.jpg','750','1241000','好人难当，ta们会觉得你装。商务合作直接私信。');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (11253297,'用户11253297','多多poi丶','https://i0.hdslb.com/bfs/face/a73660e10c210c4933f9ef496c756b5aee253917.jpg','263','2709000','日常会分享在微博～@多多poi丶 / 商务合作请联系邮箱：DDpoi@qq.com');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (946324,'用户946324','鳥取鹿子Mizuchi','https://i1.hdslb.com/bfs/face/166f626b3b5e4f7806e21b435ff12f791487b913.jpg','171','258000','Man in the mirror.丨聊天二群：766799104 淘宝：鳥取鹿子涂鸦社丨微博@鳥取鹿子');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1979774677,'用户1979774677','小米剪辑师','https://i1.hdslb.com/bfs/face/509b859e73e2054b3914f3ca38803ff2431b59a5.jpg','1101','1885','诚信第一');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (18343134,'用户18343134','林小北Lindo','https://i0.hdslb.com/bfs/face/fc093c1e6784b5f51e4697c739fe70e519ba36f7.jpg','221','1399000','商务合作WX：xiaobeibd 微博：林小北Lindo 合作邮箱：linxb1991@qq.com （菠菜勿扰）');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (190952664,'用户190952664','蕾姆琳林','https://i0.hdslb.com/bfs/face/0fa596bf4899e1327614e9894be38ff24a466602.jpg','49','22000','鹿乃\\蕾姆是天~ 每一次烦恼的出现，都是给我们寻找缺点的机会');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (434157581,'用户434157581','李格Greg','https://i2.hdslb.com/bfs/face/a9c328cc802bd56278b1c30ab63ed932f961290f.jpg','137','490000','法国/瑞士人李格，上海女婿, 中国绿卡, 舒服生活博主! 商业合作: 1520230459@qq.com');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (54911793,'用户54911793','一只黑Q','https://i0.hdslb.com/bfs/face/991a8789aa671abfb0b1c8143cff7b5ad42a1a04.jpg','10','247000','借着挑战，出门走走');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (452060800,'用户452060800','空想家欧文','https://i1.hdslb.com/bfs/face/ad3888e2d814ccd730e6da321b9c8dc9d155ce93.jpg','162','16000','');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (96109598,'用户96109598','好多喵meow','https://i2.hdslb.com/bfs/face/3e2466386a2a78f3afb3f2b8befdd36bbe2a73b3.jpg','6','246000','记录大咪小咪的沙雕日常');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (3461565017754459,'用户3461565017754459','b阿牛小卖部','https://i0.hdslb.com/bfs/face/4433f33fb898d721575855dc4335092e3cad7eaa.jpg','25','976000','分享8090后的儿时回忆 快节奏的生活中遇见怀旧的你我 记录童年发生在小卖部的点点滴滴');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (521686097,'用户521686097','LOL二哈','https://i2.hdslb.com/bfs/face/06a033deddb913b7cd3893a3dbd069c6ca4ad403.jpg','28','67000','2023年后的视频均为maya+UE5.1原创哈 感谢大家支持');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (323024456,'用户323024456','雨琪在芬兰','https://i2.hdslb.com/bfs/face/59f832f5fdb0a01391339ce842e4dae00c2f504a.jpg','13','1464000','芬兰爸爸，四川妈妈，包包兄弟和迪丽猫咪，生活在北极圈的快乐一家人✨商务小助理wx: s411109mm');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (90142376,'用户90142376','锦书致南辞','https://i2.hdslb.com/bfs/face/708e84568fc217b8437a69bd27fcf37abcfdbd52.jpg','0','1354000','合作Q：957154179');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1850119898,'用户1850119898','萌宠收藏夹','https://i2.hdslb.com/bfs/face/05abd0be41bab56ba6edeb1faca562af9f84f62b.jpg','2','9262','我已经设置了不允许任何人关注不信你试试 (〃'▽'〃)');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (11083481,'用户11083481','海东鉴宝','https://i2.hdslb.com/bfs/baselabs/f137288b2cca2adde810da0f1ac8a30c7d80aae4.png','46','94000','小助理微信❤xl_hd2022，欢迎咨询。 海东集™ 官方品牌授权账号（63301） 分享《海东鉴宝》直播间搞笑日常名场面');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1925825358,'用户1925825358','叮叮猫不咬人','https://i0.hdslb.com/bfs/face/e26ea001c0fcf83014da3ea33b64ea1bf86cfbec.jpg','93','220000','不看看怎么知道下不下饭呢/wb同名');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1474965865,'用户1474965865','少年云尘','https://i1.hdslb.com/bfs/face/307146d83dc5f3928b44012631d2d0877440b712.jpg','18','145000','横冲直撞，肆意生长。');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (400667244,'用户400667244','123IVE','https://i0.hdslb.com/bfs/face/e2a49a7e238b742bfa0b33f902d174311d9eba58.jpg','0','97000','peace & love');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (1076872109,'用户1076872109','FISH-MC','https://i2.hdslb.com/bfs/face/159201676cea3a682fe66af92b02b7df3b76de0b.jpg','25','569000','是FISH本人 商务v：UxiaoyuUawa');\n",
      "insert into users (id,username,nickname,avatar,follows,fans,introduction) values (162151104,'用户162151104','SM李秀满','https://i0.hdslb.com/bfs/face/e4df7ee5022db852ce0135c9a2ab7a3fc7f8a63b.jpg','120','244000','大四即将毕业，论文and考编找工作,缓更中 属性：EXO dw9，女团少爱（最爱墨2）');\n"
     ]
    }
   ],
   "source": [
    "uid_uniqe=[]\n",
    "for i in range(len(uid)):\n",
    "#     剔除相同up主\n",
    "    if (not uid[i] in uid_uniqe):\n",
    "        uid_uniqe.append(uid[i])\n",
    "        str_sql=\"insert into users (id,username,nickname,avatar,follows,fans,introduction) values (%s,'%s','%s','%s','%s','%s','%s');\"\n",
    "        print(str_sql%(user_data[i][0],user_data[i][1],user_data[i][2],user_data[i][3],user_data[i][4],user_data[i][5],user_data[i][6]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "video_data=[]\n",
    "for i in range(len(uid)):\n",
    "    temp=(bid[i],title[i],uid[i],img[i],views[i],likes[i],coins[i],stars[i],shares[i],introduction[i])\n",
    "    video_data.append(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(1075001008,\n",
       "  '我的外国婆婆到底是怎么进的澡堂子',\n",
       "  676128647,\n",
       "  'http://i0.hdslb.com/bfs/archive/ad6fcb5ae3d31ae88a3db425abbc0b9f3361b614.jpg',\n",
       "  401243,\n",
       "  34194,\n",
       "  1107,\n",
       "  179,\n",
       "  336,\n",
       "  ''),\n",
       " (1076767277,\n",
       "  '奥特曼光学作画师飯塚定雄逝世，享年88岁！',\n",
       "  489010625,\n",
       "  'http://i0.hdslb.com/bfs/archive/b8920c2585d692876b5c65c3c70e6948278dde8f.jpg',\n",
       "  80996,\n",
       "  10143,\n",
       "  822,\n",
       "  203,\n",
       "  1511,\n",
       "  '奥特曼光学作画师飯塚定雄逝世，享年88岁！'),\n",
       " (1075444862,\n",
       "  '直男拍照图鉴',\n",
       "  535019206,\n",
       "  'http://i0.hdslb.com/bfs/archive/143c44bb5c4e0fa2caae0b5dd4fd93d736fbc0a4.jpg',\n",
       "  316270,\n",
       "  18731,\n",
       "  570,\n",
       "  380,\n",
       "  4658,\n",
       "  '直男拍照图鉴'),\n",
       " (1071720679,\n",
       "  '中 门 对 狙',\n",
       "  6054967,\n",
       "  'http://i1.hdslb.com/bfs/archive/90b3520bd3671aaad28105f8fda9a9275560500e.jpg',\n",
       "  619085,\n",
       "  53447,\n",
       "  11938,\n",
       "  612,\n",
       "  10884,\n",
       "  '-'),\n",
       " (1075857253,\n",
       "  '没妈小猫遇见没孩猫妈妈，彼此成为彼此的救赎！',\n",
       "  498873141,\n",
       "  'http://i0.hdslb.com/bfs/archive/00b4ac0e6698703718b0da0886d10fa131ca2d07.jpg',\n",
       "  188848,\n",
       "  18524,\n",
       "  2948,\n",
       "  546,\n",
       "  62,\n",
       "  '-'),\n",
       " (1075324153,\n",
       "  '你大胆辞职！退路有的是！',\n",
       "  9094311,\n",
       "  'http://i2.hdslb.com/bfs/archive/0bccc41b3e4007d4a32866141bc9d69c9f7a4461.jpg',\n",
       "  511596,\n",
       "  29691,\n",
       "  784,\n",
       "  187,\n",
       "  658,\n",
       "  ''),\n",
       " (1072653268,\n",
       "  '中国最牛！河南胖东来！逼疯世界500强！超市天花板！妹子迷失在特价美食里！',\n",
       "  107486042,\n",
       "  'http://i2.hdslb.com/bfs/archive/495afd4ca9a58c820effccdb5686ecdeb0da4f7a.jpg',\n",
       "  1306198,\n",
       "  57830,\n",
       "  6965,\n",
       "  2948,\n",
       "  9847,\n",
       "  '发自内心的觉得胖东来并不好 想给他个建议\\n\\n\\n没开在我这里很不好 赶紧开过来！！！\\n超市里的天花板！这是真的牛！真的很尊重每一个人\\xa0\\xa0！\\n服务的魔鬼细节太细了！！服务全国超市里的顶级！\\n喜欢这个视频的朋友记得点赞三连 看过即去过 ！\\n点赞三连好运连连！'),\n",
       " (1073696607,\n",
       "  '我爱我的椅子',\n",
       "  1577804,\n",
       "  'http://i0.hdslb.com/bfs/archive/11d08c63b98529dc77a14f21bf5a3b79dac1d18b.jpg',\n",
       "  511356,\n",
       "  72598,\n",
       "  26200,\n",
       "  4413,\n",
       "  1878,\n",
       "  '当小马坐上了宝马电竞座椅的那一刻，一切就注定，不平凡。'),\n",
       " (1069179218,\n",
       "  '三 个 月 前 我 浑 身 麻 痹',\n",
       "  21979556,\n",
       "  'http://i2.hdslb.com/bfs/archive/0317435078c77f500b9c73ea8380b409513504f3.jpg',\n",
       "  391173,\n",
       "  18689,\n",
       "  2640,\n",
       "  284,\n",
       "  2820,\n",
       "  '你还有脸回来？'),\n",
       " (1076409266,\n",
       "  '深空之眼背水一战！2.0憋了个大，但是...',\n",
       "  80304,\n",
       "  'http://i2.hdslb.com/bfs/archive/c4682d5e937eef422dc7bd7d766857ddba192ed5.jpg',\n",
       "  169340,\n",
       "  16667,\n",
       "  925,\n",
       "  678,\n",
       "  350,\n",
       "  '行业太卷了，就大眼这质量，但凡早几年，不那么卷，也不至于到需要去赌一波的程度。不过大是真的好看。'),\n",
       " (1076800474,\n",
       "  '危机！幻境中的绝地求生《不良人第六季》06细节解析',\n",
       "  7946432,\n",
       "  'http://i1.hdslb.com/bfs/archive/c2f3965dd88de5126358a3b26efa4ee185837d6f.jpg',\n",
       "  111608,\n",
       "  13094,\n",
       "  5345,\n",
       "  489,\n",
       "  324,\n",
       "  '这期是细节解析，希望大家喜欢！\\n求投币！\\n求投币！\\n求投币！\\n求投币！\\n求投币！'),\n",
       " (1077032587,\n",
       "  '【少壮多弩力】用弩和弩炮通关（上）',\n",
       "  29233734,\n",
       "  'http://i2.hdslb.com/bfs/archive/ff9aff629b858f98bd7fda6c37122085d3e8590d.jpg',\n",
       "  49392,\n",
       "  4767,\n",
       "  2113,\n",
       "  634,\n",
       "  110,\n",
       "  '非攻略教学、纯看个乐、请勿较真\\n————————————————\\n据部分观众朋友说，弓弩卡面板里技早些时候被修复了，于是有了这期无里技向视频（），由于弓弩数量较多，所以单独拆出弩来玩玩，“弓和大弓”则看情况\\n\\n游戏版本：1.08.1和1.09\\n视频灵感来源：ymfah、DC伯爵\\n全弩满强化面板参考：BV1Va41187px\\n火山失色7邪道参考：BV1j8411Y7w5\\n\\n【本轮游戏规则】\\n目标：通关主线\\n*手上只装备弩或弩炮类武器\\n*其他随意'),\n",
       " (1074409876,\n",
       "  '益生菌/护肝片有用？献血有好处？那些让医生反复横跳的谣言！',\n",
       "  208130286,\n",
       "  'http://i0.hdslb.com/bfs/archive/6573d1fd0f3abc805c9036fd0c530eea4a2f1f21.jpg',\n",
       "  411951,\n",
       "  23533,\n",
       "  9072,\n",
       "  4157,\n",
       "  2713,\n",
       "  ''),\n",
       " (1073086589,\n",
       "  '我是新手，该买什么相机？从2k到4w，年度相机大盘点！',\n",
       "  946974,\n",
       "  'http://i1.hdslb.com/bfs/archive/68d58e0ed9a03e89fae3162e46d123154b923000.jpg',\n",
       "  1160379,\n",
       "  96794,\n",
       "  52673,\n",
       "  8828,\n",
       "  21618,\n",
       "  '这次我们开启了一个全新系列，盘点市面上大部分的相机，结合自己的使用体验和市场的主流评价，挑选出不同赛道的优胜选手，希望能给你挑选相机一点帮助！如果你喜欢本期视频，别忘了给我们点赞投币！'),\n",
       " (1076726002,\n",
       "  '【即兴改画96】观感提升！如何提升插画的专业感',\n",
       "  1688563568,\n",
       "  'http://i1.hdslb.com/bfs/archive/4d0acb85cdda81aec32367fb1252aaa22db8d3ae.jpg',\n",
       "  32493,\n",
       "  6151,\n",
       "  820,\n",
       "  483,\n",
       "  124,\n",
       "  '感谢作者「Pha（ふぁを）」的作品，标题为「我渴望你的死亡（貴方の死を望みます）」。\\n\\n新的即兴改画投稿问卷：\\nhttps://forms.gle/RKbkbQuA6rMoXcKb6\\n需要网络环境才能访问，如使用翻译软件填写请注明。\\n\\n译制·协力 @卡米雷特'),\n",
       " (1074286238,\n",
       "  '这个游戏告诉你什么叫【武德】·《sifu》',\n",
       "  28266043,\n",
       "  'http://i2.hdslb.com/bfs/archive/b754fd8bad97237d11c4323a915b86de57e9c03b.jpg',\n",
       "  269980,\n",
       "  26633,\n",
       "  15156,\n",
       "  1639,\n",
       "  869,\n",
       "  '一款你以为是青铜实则是王者的游戏，《sifu》。让我在复仇游戏中体会了“饶恕你，与你何干？”的境界。【武德】的本质是什么？这款游戏为你深刻诠释。\\n┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┅┄┅┄┅\\nBGM：Sifu Digital Original Soundtrack-Howie\\xa0Lee\\n┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┅┄┅┄┅\\n本期部分精彩操作部分由以下师父们提供：\\n6分52秒：\\n片段表演：沉沦DESCEND\\xa0\\n片段解说：霜小花呀\\n素材提供：D哥不鸽\\xa0\\nBoss：\\n法贾：接受设定的大明\\n肖恩：老巴西\\n锦凤：JC橘橙\\n黑木&扬：空嚣亦成风吟'),\n",
       " (1071272790,\n",
       "  '年货（0分钟空气版）',\n",
       "  527277977,\n",
       "  'http://i2.hdslb.com/bfs/archive/2c7a0a09b4ed431427b382a11ef45b3656d2c9f3.jpg',\n",
       "  334216,\n",
       "  37150,\n",
       "  13396,\n",
       "  2732,\n",
       "  1523,\n",
       "  '-up做了三个月，快要累死了呜呜呜，求求大家给个三连吧'),\n",
       " (1076765438,\n",
       "  '【平远说】从特战精英到保障有力——“军人服务社”的历史由来与职能介绍',\n",
       "  473500781,\n",
       "  'http://i1.hdslb.com/bfs/archive/c3279486697139b871ff86fa86309880fa1eb41f.jpg',\n",
       "  113597,\n",
       "  9039,\n",
       "  1504,\n",
       "  490,\n",
       "  68,\n",
       "  '好耶'),\n",
       " (1076854443,\n",
       "  '关于大阪的记忆',\n",
       "  1956887620,\n",
       "  'http://i0.hdslb.com/bfs/archive/a879f94f2056b80de0aca0d8aeae537190b15f88.jpg',\n",
       "  101617,\n",
       "  8893,\n",
       "  5109,\n",
       "  1475,\n",
       "  324,\n",
       "  '-'),\n",
       " (1075957789,\n",
       "  '这是我四年来一直做的梦',\n",
       "  35539283,\n",
       "  'http://i1.hdslb.com/bfs/archive/9e244d9357852367b07391cd2df9f55a1b691cc3.jpg',\n",
       "  344577,\n",
       "  8892,\n",
       "  2753,\n",
       "  569,\n",
       "  204,\n",
       "  '回家'),\n",
       " (1075454991,\n",
       "  '上去下不来的两个大聪明',\n",
       "  508416316,\n",
       "  'http://i0.hdslb.com/bfs/archive/e34970aba8aecf9399dfe28f33603e82d4dddd9b.jpg',\n",
       "  493590,\n",
       "  63491,\n",
       "  7873,\n",
       "  765,\n",
       "  539,\n",
       "  '-'),\n",
       " (1069834414,\n",
       "  '《时空中的绘旅人》全新活动「瑰梦奇境」PV首曝：迷雾惊疑，瑰梦循路',\n",
       "  441833336,\n",
       "  'http://i0.hdslb.com/bfs/archive/72344db88ed0fee5b36f985ef367077cc7e57447.jpg',\n",
       "  795632,\n",
       "  42232,\n",
       "  9794,\n",
       "  1286,\n",
       "  10029,\n",
       "  '【全新活动「瑰梦奇境」PV公开】\\n\\n窃窃私语、窃窃私语，乌鸦在嘲笑；\\n簌簌书声、簌簌书声，时间会停滞。\\n跑啊，勿听那迷离笛音；逃吧，勿视那盈润满月。\\n真相是否重要？觉醒或是覆灭，只在瞬息之间。\\n\\n全新活动「瑰梦奇境」上篇将于3月30日更新后开启。迷雾惊疑，瑰梦循路。在混沌的怪奇小镇中，见证长眠者的苏生。\\n※ 更多画灵情报、全新玩法及福利内容，请留意后续公告。\\n\\n立即下载游戏：https://www.biligame.com/detail/?id=103915&sourceFrom=1112\\xa0\\nB站专属官方Q群：1047078077'),\n",
       " (1072594268,\n",
       "  '七七:Ai大叔，阔以给我也画个嘛',\n",
       "  391636983,\n",
       "  'http://i2.hdslb.com/bfs/archive/7a016cd12b22d1d829608764bc5377f9255097e6.jpg',\n",
       "  920273,\n",
       "  43307,\n",
       "  1059,\n",
       "  88,\n",
       "  2130,\n",
       "  'AI绘画:stable diffusion\\nmodel : miHoYo/观海/\\nstage： 柠檬香草\\nMotion :JonnyL\\nMME: Rui / そぼろ / ビームマンP / ikeno / データP\\nBGM : n/a'),\n",
       " (1076855597,\n",
       "  '学妹也恋爱告急了！！！❤️(๑⁼̴̀д⁼̴́๑)',\n",
       "  434476793,\n",
       "  'http://i2.hdslb.com/bfs/archive/d26407026668dc85499ab7a770044d84e6da5fe0.jpg',\n",
       "  88300,\n",
       "  5808,\n",
       "  1556,\n",
       "  75,\n",
       "  161,\n",
       "  '音乐：鞠婧祎《恋爱告急》\\n\\n欢迎光临简介～\\n又是新风格～不知道大家觉得如何呀，我深知自己还需要多多多多的练习，目前还是没办法把这种舞蹈很好地呈现出来……这支舞经历了两次录制，最近几乎是每周录，每周更，好忙好忙（真的很佩服我自己！！）\\n\\n争取下次更好！希望能让你们一直看到进步'),\n",
       " (1075016871,\n",
       "  '好励志，美国励志哥',\n",
       "  415403269,\n",
       "  'http://i1.hdslb.com/bfs/archive/6cdf721e54d7323d4aa9aa707aecc7ebbfcb2823.jpg',\n",
       "  427475,\n",
       "  31501,\n",
       "  1272,\n",
       "  293,\n",
       "  7863,\n",
       "  '微博@internet-garcon-pdf\\n好励志，美国励志哥'),\n",
       " (1076713183,\n",
       "  '玟星+颂乐小分队回归曲GGBB首打歌舞台',\n",
       "  16720403,\n",
       "  'http://i2.hdslb.com/bfs/archive/1f2584bb6f0ea076e33df3dc34406af4a78792f8.jpg',\n",
       "  110976,\n",
       "  8611,\n",
       "  1360,\n",
       "  543,\n",
       "  1228,\n",
       "  'yt'),\n",
       " (1071642301,\n",
       "  '十年后你儿子问你：现在电影这么烂你当初怎么看下去的？',\n",
       "  56345895,\n",
       "  'http://i0.hdslb.com/bfs/archive/ee97e6d7f47ff9ad180d85518b43171db43942d0.jpg',\n",
       "  403931,\n",
       "  27113,\n",
       "  3473,\n",
       "  362,\n",
       "  697,\n",
       "  '于是你给他看了这些电影'),\n",
       " (1076493184,\n",
       "  '龙蜥：人家主播都是秒我，这主播是过来表演才艺。',\n",
       "  17603188,\n",
       "  'http://i0.hdslb.com/bfs/archive/3cc4d2c28bbf1d35e580eaf4826eebd6f34229c3.jpg',\n",
       "  141923,\n",
       "  17016,\n",
       "  2627,\n",
       "  613,\n",
       "  1108,\n",
       "  'B站直播间直达链接：https://live.bilibili.com/8864977\\n原神开播通知群：472129011\\n更新的一般都是娱乐视频\\n感谢大家关注~！！！'),\n",
       " (1070399105,\n",
       "  '浅唱一段铃芽之旅主题曲《すずめ》【多多poi】',\n",
       "  11253297,\n",
       "  'http://i2.hdslb.com/bfs/archive/b28c8c3bd865658e5cfab8ecf0e3c38de1a3f628.jpg',\n",
       "  988907,\n",
       "  155841,\n",
       "  21602,\n",
       "  565,\n",
       "  5444,\n",
       "  '尝试了一种新的翻唱形式！\\n唱了一小段《すずめ》\\n混音：猫耳studio'),\n",
       " (1074741987,\n",
       "  '印度技能戏耍屠夫流逃生者 一挂升天被守到死的快乐你体验过吗~',\n",
       "  946324,\n",
       "  'http://i2.hdslb.com/bfs/archive/e87eb06dbf8821a92f275b9fabaea488440c612a.jpg',\n",
       "  286382,\n",
       "  24408,\n",
       "  1539,\n",
       "  639,\n",
       "  280,\n",
       "  '感谢枪手配音@Coooooowboy  \\n感谢凤敏配音@忙着做梦的风棂  \\n\\n====================================================================\\n\\n• 如果你喜欢我的视频可以点一下推荐&投币&收藏 :D\\n\\n► 欢迎评论以及私信，每一条我都会看 :D\\n\\n► 如果你想看更多此类视频欢迎关注 ^^@@\\n\\nʟᴏᴠᴇ ɪs ᴀʟʟ ᴡᴇ ɴᴇᴇᴅ.'),\n",
       " (1068976758,\n",
       "  '“28年革命，你以为升起来的仅仅是一块红布吗”',\n",
       "  1979774677,\n",
       "  'http://i0.hdslb.com/bfs/archive/c15170bc2ab7c22982f339056d43237f46855516.jpg',\n",
       "  54183,\n",
       "  18062,\n",
       "  3459,\n",
       "  76,\n",
       "  55,\n",
       "  '-'),\n",
       " (1075308912,\n",
       "  '一分钟学会新版源计划狼人！热补上线，国服前三阵容一分钟学会！ 【云顶之弈】【 金铲铲之战】',\n",
       "  18343134,\n",
       "  'http://i2.hdslb.com/bfs/archive/0b55798dd38be15ea6d6299a2295c3d34d40f251.jpg',\n",
       "  288709,\n",
       "  18096,\n",
       "  1105,\n",
       "  96,\n",
       "  774,\n",
       "  '这个不是加更挑战，这个不是加更挑战，这个不是加更挑战\\n加更挑战因为热补的关系，需要重新测试环境，正在制作中\\n不要忘记点个赞哦！'),\n",
       " (1074896232,\n",
       "  '我的剑将劈开薯片!',\n",
       "  190952664,\n",
       "  'http://i1.hdslb.com/bfs/archive/aeeb048de4726b365e638fc3c689560e69f1fd76.jpg',\n",
       "  263998,\n",
       "  32893,\n",
       "  1793,\n",
       "  124,\n",
       "  5203,\n",
       "  '原视频：BV1Df4y1V7Ah\\n虽然他俩都不是海鸥，但也挺合理的(´･ω･`)?'),\n",
       " (1074168145,\n",
       "  '法国人24小时看小潮院长, 不会把自己看死了吗?',\n",
       "  434157581,\n",
       "  'http://i0.hdslb.com/bfs/archive/fd30a505d16a83a3aaae269d46d07780de9cd425.jpg',\n",
       "  385748,\n",
       "  32237,\n",
       "  2849,\n",
       "  885,\n",
       "  320,\n",
       "  '我终于看了你们都推荐的中国博主小潮院长的视频! 问题是... 我挺喜欢!'),\n",
       " (1071738170,\n",
       "  '挑战！随机任务吃美食！选惠灵顿牛排还是蟹黄面？',\n",
       "  54911793,\n",
       "  'http://i2.hdslb.com/bfs/archive/e827e89ec55fe3d5f770db036af92ecefadf84e6.jpg',\n",
       "  2097595,\n",
       "  21943,\n",
       "  5689,\n",
       "  357,\n",
       "  85,\n",
       "  '-'),\n",
       " (1072647882,\n",
       "  '防盗墓机关之“断龙石天顶沙”',\n",
       "  452060800,\n",
       "  'http://i0.hdslb.com/bfs/archive/85941472cc9fd19d8f5f1951c294b29379c44fa7.jpg',\n",
       "  401587,\n",
       "  12814,\n",
       "  1100,\n",
       "  522,\n",
       "  548,\n",
       "  '灵感来自小伙伴和小说，仅供参考娱乐'),\n",
       " (1075955026,\n",
       "  '七年以来第二次大战，小咪败～',\n",
       "  96109598,\n",
       "  'http://i0.hdslb.com/bfs/archive/7b683520213796bac63328b93bb54e25ed5d30a3.jpg',\n",
       "  194278,\n",
       "  22493,\n",
       "  673,\n",
       "  240,\n",
       "  729,\n",
       "  '-'),\n",
       " (1075515223,\n",
       "  '龙哥霸气归来，村里要有大事发生！',\n",
       "  3461565017754459,\n",
       "  'http://i2.hdslb.com/bfs/archive/117214bbd2fac7672add43dca41067b4dcd25cf4.jpg',\n",
       "  480126,\n",
       "  32977,\n",
       "  1271,\n",
       "  1576,\n",
       "  389,\n",
       "  '-'),\n",
       " (1068948883,\n",
       "  '英雄联盟：没有音响的潘森，能打过剑魔吗？来感受下战争星灵的压迫感！',\n",
       "  521686097,\n",
       "  'http://i2.hdslb.com/bfs/archive/93efd2e90d7953cd748d7190a467680b3e8ca9ad.jpg',\n",
       "  399197,\n",
       "  29854,\n",
       "  1079,\n",
       "  68,\n",
       "  264,\n",
       "  '学了180天的游戏动画，这个作品当毕业设计了\\xa0\\n显卡：好看吗？我拿命换的！\\n之前有个观众老爷要帅的视频\\n我觉得前半部分还挺帅 哈哈'),\n",
       " (1074209209,\n",
       "  '芬兰家人血战爆辣湘菜馆子辣到飙泪！一口剁椒一口酸豆角爽翻天！汤汁喝干净！奶茶上瘾到想马上去中国！',\n",
       "  323024456,\n",
       "  'http://i0.hdslb.com/bfs/archive/6ec5fbbd98e4c1947539ccc95c363c954ed5196d.jpg',\n",
       "  696049,\n",
       "  61183,\n",
       "  29703,\n",
       "  3603,\n",
       "  563,\n",
       "  '芬兰家人第一次见识到传说中湖南馆子爆辣程度被惊呆了！\\n剁椒排骨，爆辣金钱肚，酸豆角炒牛肉简直太过瘾！一口剁椒一口蒜蓉简直上头！蒜蓉粉丝虾和卤牛肉简直惊艳了侄儿侄女，获得一致好评！居然汤都被喝的干干净净？！侄子已经是奶茶专家，恨不得一天N杯奶茶，直呼想马上去中国！还有和侄儿侄女逛街的哈哈哈日常，希望大家看的开心！\\n\\n*本视频含合作【摇滚动物园】谢谢大家的支持，我们才有合作的机会！'),\n",
       " (1073815725,\n",
       "  '世界盛大灿烂，你可以是千千万万',\n",
       "  90142376,\n",
       "  'http://i1.hdslb.com/bfs/archive/f7bf541b55b0d0a7d1214afa5c505463e5d4cb92.jpg',\n",
       "  296346,\n",
       "  23144,\n",
       "  4522,\n",
       "  368,\n",
       "  1208,\n",
       "  'BGM：莫西子诗 - 不要怕&啊杰咯'),\n",
       " (1072081711,\n",
       "  '“三斤的小猫，七斤的可爱！！”',\n",
       "  1850119898,\n",
       "  'http://i0.hdslb.com/bfs/archive/b2776da6f3fbd5e412873872c788057fb593df24.jpg',\n",
       "  318990,\n",
       "  14166,\n",
       "  835,\n",
       "  248,\n",
       "  1346,\n",
       "  ''),\n",
       " (1072938807,\n",
       "  '问题不大，终身监禁｜【海东老师】2023年3月27日直播',\n",
       "  11083481,\n",
       "  'http://i2.hdslb.com/bfs/archive/769f433e3f953afe344ca457daec0236b510ec00.jpg',\n",
       "  784739,\n",
       "  19531,\n",
       "  1737,\n",
       "  9421,\n",
       "  2920,\n",
       "  '-'),\n",
       " (1075984023,\n",
       "  '泰坦尼克号头等舱二等舱和三等舱的食物都有什么不同？连餐具都差这么多？【叮叮猫不咬人】',\n",
       "  1925825358,\n",
       "  'http://i1.hdslb.com/bfs/archive/3f772e7d5d842257ed6290136cee5743dc1d696e.jpg',\n",
       "  126832,\n",
       "  7496,\n",
       "  1598,\n",
       "  759,\n",
       "  187,\n",
       "  '啊'),\n",
       " (1069028813,\n",
       "  '一个人去吃饭的路上，有棵树治好了我的孤独。',\n",
       "  1474965865,\n",
       "  'http://i1.hdslb.com/bfs/archive/6220339910ece848b0604d9904c07318018a719d.jpg',\n",
       "  1107027,\n",
       "  149872,\n",
       "  12449,\n",
       "  646,\n",
       "  2989,\n",
       "  '-'),\n",
       " (1072886181,\n",
       "  'IVE回归先行曲《Kitsch》MV',\n",
       "  400667244,\n",
       "  'http://i2.hdslb.com/bfs/archive/88cca839c2fd657290d3443689bba0103176b341.jpg',\n",
       "  461015,\n",
       "  16734,\n",
       "  1366,\n",
       "  1135,\n",
       "  4670,\n",
       "  'IVE'),\n",
       " (1070912246,\n",
       "  '服务器刚开服一周竟然就遭遇了毁灭式攻击！！！！',\n",
       "  1076872109,\n",
       "  'http://i0.hdslb.com/bfs/archive/ac93c0ee2a321129fd6ddfea8bc936e8b65e2400.jpg',\n",
       "  757104,\n",
       "  135902,\n",
       "  29080,\n",
       "  1075,\n",
       "  269,\n",
       "  '相信大家看完视频了，这两天修复真的费了我们不少精力\\n视频结尾提到如何进入服务器 \\n这里是🐧裙：740606046\\n进裙后会有详细教程哦'),\n",
       " (1076166115,\n",
       "  '金钟仁&边伯贤&吴世勋《Rover》舞蹈Challenge！🐥🐻🐶',\n",
       "  162151104,\n",
       "  'http://i0.hdslb.com/bfs/archive/811c1908dbe64175c2719360f7d76a5553856035.jpg',\n",
       "  140891,\n",
       "  23290,\n",
       "  1433,\n",
       "  371,\n",
       "  1794,\n",
       "  '网络')]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "video_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075001008,'我的外国婆婆到底是怎么进的澡堂子',676128647,'http://i0.hdslb.com/bfs/archive/ad6fcb5ae3d31ae88a3db425abbc0b9f3361b614.jpg',401243,34194,1107,179,336,'');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076767277,'奥特曼光学作画师飯塚定雄逝世，享年88岁！',489010625,'http://i0.hdslb.com/bfs/archive/b8920c2585d692876b5c65c3c70e6948278dde8f.jpg',80996,10143,822,203,1511,'奥特曼光学作画师飯塚定雄逝世，享年88岁！');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075444862,'直男拍照图鉴',535019206,'http://i0.hdslb.com/bfs/archive/143c44bb5c4e0fa2caae0b5dd4fd93d736fbc0a4.jpg',316270,18731,570,380,4658,'直男拍照图鉴');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1071720679,'中 门 对 狙',6054967,'http://i1.hdslb.com/bfs/archive/90b3520bd3671aaad28105f8fda9a9275560500e.jpg',619085,53447,11938,612,10884,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075857253,'没妈小猫遇见没孩猫妈妈，彼此成为彼此的救赎！',498873141,'http://i0.hdslb.com/bfs/archive/00b4ac0e6698703718b0da0886d10fa131ca2d07.jpg',188848,18524,2948,546,62,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075324153,'你大胆辞职！退路有的是！',9094311,'http://i2.hdslb.com/bfs/archive/0bccc41b3e4007d4a32866141bc9d69c9f7a4461.jpg',511596,29691,784,187,658,'');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1072653268,'中国最牛！河南胖东来！逼疯世界500强！超市天花板！妹子迷失在特价美食里！',107486042,'http://i2.hdslb.com/bfs/archive/495afd4ca9a58c820effccdb5686ecdeb0da4f7a.jpg',1306198,57830,6965,2948,9847,'发自内心的觉得胖东来并不好 想给他个建议\n",
      "\n",
      "\n",
      "没开在我这里很不好 赶紧开过来！！！\n",
      "超市里的天花板！这是真的牛！真的很尊重每一个人  ！\n",
      "服务的魔鬼细节太细了！！服务全国超市里的顶级！\n",
      "喜欢这个视频的朋友记得点赞三连 看过即去过 ！\n",
      "点赞三连好运连连！');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1073696607,'我爱我的椅子',1577804,'http://i0.hdslb.com/bfs/archive/11d08c63b98529dc77a14f21bf5a3b79dac1d18b.jpg',511356,72598,26200,4413,1878,'当小马坐上了宝马电竞座椅的那一刻，一切就注定，不平凡。');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1069179218,'三 个 月 前 我 浑 身 麻 痹',21979556,'http://i2.hdslb.com/bfs/archive/0317435078c77f500b9c73ea8380b409513504f3.jpg',391173,18689,2640,284,2820,'你还有脸回来？');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076409266,'深空之眼背水一战！2.0憋了个大，但是...',80304,'http://i2.hdslb.com/bfs/archive/c4682d5e937eef422dc7bd7d766857ddba192ed5.jpg',169340,16667,925,678,350,'行业太卷了，就大眼这质量，但凡早几年，不那么卷，也不至于到需要去赌一波的程度。不过大是真的好看。');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076800474,'危机！幻境中的绝地求生《不良人第六季》06细节解析',7946432,'http://i1.hdslb.com/bfs/archive/c2f3965dd88de5126358a3b26efa4ee185837d6f.jpg',111608,13094,5345,489,324,'这期是细节解析，希望大家喜欢！\n",
      "求投币！\n",
      "求投币！\n",
      "求投币！\n",
      "求投币！\n",
      "求投币！');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1077032587,'【少壮多弩力】用弩和弩炮通关（上）',29233734,'http://i2.hdslb.com/bfs/archive/ff9aff629b858f98bd7fda6c37122085d3e8590d.jpg',49392,4767,2113,634,110,'非攻略教学、纯看个乐、请勿较真\n",
      "————————————————\n",
      "据部分观众朋友说，弓弩卡面板里技早些时候被修复了，于是有了这期无里技向视频（），由于弓弩数量较多，所以单独拆出弩来玩玩，“弓和大弓”则看情况\n",
      "\n",
      "游戏版本：1.08.1和1.09\n",
      "视频灵感来源：ymfah、DC伯爵\n",
      "全弩满强化面板参考：BV1Va41187px\n",
      "火山失色7邪道参考：BV1j8411Y7w5\n",
      "\n",
      "【本轮游戏规则】\n",
      "目标：通关主线\n",
      "*手上只装备弩或弩炮类武器\n",
      "*其他随意');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1074409876,'益生菌/护肝片有用？献血有好处？那些让医生反复横跳的谣言！',208130286,'http://i0.hdslb.com/bfs/archive/6573d1fd0f3abc805c9036fd0c530eea4a2f1f21.jpg',411951,23533,9072,4157,2713,'');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1073086589,'我是新手，该买什么相机？从2k到4w，年度相机大盘点！',946974,'http://i1.hdslb.com/bfs/archive/68d58e0ed9a03e89fae3162e46d123154b923000.jpg',1160379,96794,52673,8828,21618,'这次我们开启了一个全新系列，盘点市面上大部分的相机，结合自己的使用体验和市场的主流评价，挑选出不同赛道的优胜选手，希望能给你挑选相机一点帮助！如果你喜欢本期视频，别忘了给我们点赞投币！');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076726002,'【即兴改画96】观感提升！如何提升插画的专业感',1688563568,'http://i1.hdslb.com/bfs/archive/4d0acb85cdda81aec32367fb1252aaa22db8d3ae.jpg',32493,6151,820,483,124,'感谢作者「Pha（ふぁを）」的作品，标题为「我渴望你的死亡（貴方の死を望みます）」。\n",
      "\n",
      "新的即兴改画投稿问卷：\n",
      "https://forms.gle/RKbkbQuA6rMoXcKb6\n",
      "需要网络环境才能访问，如使用翻译软件填写请注明。\n",
      "\n",
      "译制·协力 @卡米雷特');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1074286238,'这个游戏告诉你什么叫【武德】·《sifu》',28266043,'http://i2.hdslb.com/bfs/archive/b754fd8bad97237d11c4323a915b86de57e9c03b.jpg',269980,26633,15156,1639,869,'一款你以为是青铜实则是王者的游戏，《sifu》。让我在复仇游戏中体会了“饶恕你，与你何干？”的境界。【武德】的本质是什么？这款游戏为你深刻诠释。\n",
      "┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┅┄┅┄┅\n",
      "BGM：Sifu Digital Original Soundtrack-Howie Lee\n",
      "┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┄┅┅┄┅┄┅\n",
      "本期部分精彩操作部分由以下师父们提供：\n",
      "6分52秒：\n",
      "片段表演：沉沦DESCEND \n",
      "片段解说：霜小花呀\n",
      "素材提供：D哥不鸽 \n",
      "Boss：\n",
      "法贾：接受设定的大明\n",
      "肖恩：老巴西\n",
      "锦凤：JC橘橙\n",
      "黑木&扬：空嚣亦成风吟');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1071272790,'年货（0分钟空气版）',527277977,'http://i2.hdslb.com/bfs/archive/2c7a0a09b4ed431427b382a11ef45b3656d2c9f3.jpg',334216,37150,13396,2732,1523,'-up做了三个月，快要累死了呜呜呜，求求大家给个三连吧');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076765438,'【平远说】从特战精英到保障有力——“军人服务社”的历史由来与职能介绍',473500781,'http://i1.hdslb.com/bfs/archive/c3279486697139b871ff86fa86309880fa1eb41f.jpg',113597,9039,1504,490,68,'好耶');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076854443,'关于大阪的记忆',1956887620,'http://i0.hdslb.com/bfs/archive/a879f94f2056b80de0aca0d8aeae537190b15f88.jpg',101617,8893,5109,1475,324,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075957789,'这是我四年来一直做的梦',35539283,'http://i1.hdslb.com/bfs/archive/9e244d9357852367b07391cd2df9f55a1b691cc3.jpg',344577,8892,2753,569,204,'回家');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075454991,'上去下不来的两个大聪明',508416316,'http://i0.hdslb.com/bfs/archive/e34970aba8aecf9399dfe28f33603e82d4dddd9b.jpg',493590,63491,7873,765,539,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1069834414,'《时空中的绘旅人》全新活动「瑰梦奇境」PV首曝：迷雾惊疑，瑰梦循路',441833336,'http://i0.hdslb.com/bfs/archive/72344db88ed0fee5b36f985ef367077cc7e57447.jpg',795632,42232,9794,1286,10029,'【全新活动「瑰梦奇境」PV公开】\n",
      "\n",
      "窃窃私语、窃窃私语，乌鸦在嘲笑；\n",
      "簌簌书声、簌簌书声，时间会停滞。\n",
      "跑啊，勿听那迷离笛音；逃吧，勿视那盈润满月。\n",
      "真相是否重要？觉醒或是覆灭，只在瞬息之间。\n",
      "\n",
      "全新活动「瑰梦奇境」上篇将于3月30日更新后开启。迷雾惊疑，瑰梦循路。在混沌的怪奇小镇中，见证长眠者的苏生。\n",
      "※ 更多画灵情报、全新玩法及福利内容，请留意后续公告。\n",
      "\n",
      "立即下载游戏：https://www.biligame.com/detail/?id=103915&sourceFrom=1112 \n",
      "B站专属官方Q群：1047078077');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1072594268,'七七:Ai大叔，阔以给我也画个嘛',391636983,'http://i2.hdslb.com/bfs/archive/7a016cd12b22d1d829608764bc5377f9255097e6.jpg',920273,43307,1059,88,2130,'AI绘画:stable diffusion\n",
      "model : miHoYo/观海/\n",
      "stage： 柠檬香草\n",
      "Motion :JonnyL\n",
      "MME: Rui / そぼろ / ビームマンP / ikeno / データP\n",
      "BGM : n/a');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076855597,'学妹也恋爱告急了！！！❤️(๑⁼̴̀д⁼̴́๑)',434476793,'http://i2.hdslb.com/bfs/archive/d26407026668dc85499ab7a770044d84e6da5fe0.jpg',88300,5808,1556,75,161,'音乐：鞠婧祎《恋爱告急》\n",
      "\n",
      "欢迎光临简介～\n",
      "又是新风格～不知道大家觉得如何呀，我深知自己还需要多多多多的练习，目前还是没办法把这种舞蹈很好地呈现出来……这支舞经历了两次录制，最近几乎是每周录，每周更，好忙好忙（真的很佩服我自己！！）\n",
      "\n",
      "争取下次更好！希望能让你们一直看到进步');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075016871,'好励志，美国励志哥',415403269,'http://i1.hdslb.com/bfs/archive/6cdf721e54d7323d4aa9aa707aecc7ebbfcb2823.jpg',427475,31501,1272,293,7863,'微博@internet-garcon-pdf\n",
      "好励志，美国励志哥');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076713183,'玟星+颂乐小分队回归曲GGBB首打歌舞台',16720403,'http://i2.hdslb.com/bfs/archive/1f2584bb6f0ea076e33df3dc34406af4a78792f8.jpg',110976,8611,1360,543,1228,'yt');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1071642301,'十年后你儿子问你：现在电影这么烂你当初怎么看下去的？',56345895,'http://i0.hdslb.com/bfs/archive/ee97e6d7f47ff9ad180d85518b43171db43942d0.jpg',403931,27113,3473,362,697,'于是你给他看了这些电影');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076493184,'龙蜥：人家主播都是秒我，这主播是过来表演才艺。',17603188,'http://i0.hdslb.com/bfs/archive/3cc4d2c28bbf1d35e580eaf4826eebd6f34229c3.jpg',141923,17016,2627,613,1108,'B站直播间直达链接：https://live.bilibili.com/8864977\n",
      "原神开播通知群：472129011\n",
      "更新的一般都是娱乐视频\n",
      "感谢大家关注~！！！');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1070399105,'浅唱一段铃芽之旅主题曲《すずめ》【多多poi】',11253297,'http://i2.hdslb.com/bfs/archive/b28c8c3bd865658e5cfab8ecf0e3c38de1a3f628.jpg',988907,155841,21602,565,5444,'尝试了一种新的翻唱形式！\n",
      "唱了一小段《すずめ》\n",
      "混音：猫耳studio');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1074741987,'印度技能戏耍屠夫流逃生者 一挂升天被守到死的快乐你体验过吗~',946324,'http://i2.hdslb.com/bfs/archive/e87eb06dbf8821a92f275b9fabaea488440c612a.jpg',286382,24408,1539,639,280,'感谢枪手配音@Coooooowboy  \n",
      "感谢凤敏配音@忙着做梦的风棂  \n",
      "\n",
      "====================================================================\n",
      "\n",
      "• 如果你喜欢我的视频可以点一下推荐&投币&收藏 :D\n",
      "\n",
      "► 欢迎评论以及私信，每一条我都会看 :D\n",
      "\n",
      "► 如果你想看更多此类视频欢迎关注 ^^@@\n",
      "\n",
      "ʟᴏᴠᴇ ɪs ᴀʟʟ ᴡᴇ ɴᴇᴇᴅ.');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1068976758,'“28年革命，你以为升起来的仅仅是一块红布吗”',1979774677,'http://i0.hdslb.com/bfs/archive/c15170bc2ab7c22982f339056d43237f46855516.jpg',54183,18062,3459,76,55,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075308912,'一分钟学会新版源计划狼人！热补上线，国服前三阵容一分钟学会！ 【云顶之弈】【 金铲铲之战】',18343134,'http://i2.hdslb.com/bfs/archive/0b55798dd38be15ea6d6299a2295c3d34d40f251.jpg',288709,18096,1105,96,774,'这个不是加更挑战，这个不是加更挑战，这个不是加更挑战\n",
      "加更挑战因为热补的关系，需要重新测试环境，正在制作中\n",
      "不要忘记点个赞哦！');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1074896232,'我的剑将劈开薯片!',190952664,'http://i1.hdslb.com/bfs/archive/aeeb048de4726b365e638fc3c689560e69f1fd76.jpg',263998,32893,1793,124,5203,'原视频：BV1Df4y1V7Ah\n",
      "虽然他俩都不是海鸥，但也挺合理的(´･ω･`)?');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1074168145,'法国人24小时看小潮院长, 不会把自己看死了吗?',434157581,'http://i0.hdslb.com/bfs/archive/fd30a505d16a83a3aaae269d46d07780de9cd425.jpg',385748,32237,2849,885,320,'我终于看了你们都推荐的中国博主小潮院长的视频! 问题是... 我挺喜欢!');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1071738170,'挑战！随机任务吃美食！选惠灵顿牛排还是蟹黄面？',54911793,'http://i2.hdslb.com/bfs/archive/e827e89ec55fe3d5f770db036af92ecefadf84e6.jpg',2097595,21943,5689,357,85,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1072647882,'防盗墓机关之“断龙石天顶沙”',452060800,'http://i0.hdslb.com/bfs/archive/85941472cc9fd19d8f5f1951c294b29379c44fa7.jpg',401587,12814,1100,522,548,'灵感来自小伙伴和小说，仅供参考娱乐');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075955026,'七年以来第二次大战，小咪败～',96109598,'http://i0.hdslb.com/bfs/archive/7b683520213796bac63328b93bb54e25ed5d30a3.jpg',194278,22493,673,240,729,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075515223,'龙哥霸气归来，村里要有大事发生！',3461565017754459,'http://i2.hdslb.com/bfs/archive/117214bbd2fac7672add43dca41067b4dcd25cf4.jpg',480126,32977,1271,1576,389,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1068948883,'英雄联盟：没有音响的潘森，能打过剑魔吗？来感受下战争星灵的压迫感！',521686097,'http://i2.hdslb.com/bfs/archive/93efd2e90d7953cd748d7190a467680b3e8ca9ad.jpg',399197,29854,1079,68,264,'学了180天的游戏动画，这个作品当毕业设计了 \n",
      "显卡：好看吗？我拿命换的！\n",
      "之前有个观众老爷要帅的视频\n",
      "我觉得前半部分还挺帅 哈哈');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1074209209,'芬兰家人血战爆辣湘菜馆子辣到飙泪！一口剁椒一口酸豆角爽翻天！汤汁喝干净！奶茶上瘾到想马上去中国！',323024456,'http://i0.hdslb.com/bfs/archive/6ec5fbbd98e4c1947539ccc95c363c954ed5196d.jpg',696049,61183,29703,3603,563,'芬兰家人第一次见识到传说中湖南馆子爆辣程度被惊呆了！\n",
      "剁椒排骨，爆辣金钱肚，酸豆角炒牛肉简直太过瘾！一口剁椒一口蒜蓉简直上头！蒜蓉粉丝虾和卤牛肉简直惊艳了侄儿侄女，获得一致好评！居然汤都被喝的干干净净？！侄子已经是奶茶专家，恨不得一天N杯奶茶，直呼想马上去中国！还有和侄儿侄女逛街的哈哈哈日常，希望大家看的开心！\n",
      "\n",
      "*本视频含合作【摇滚动物园】谢谢大家的支持，我们才有合作的机会！');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1073815725,'世界盛大灿烂，你可以是千千万万',90142376,'http://i1.hdslb.com/bfs/archive/f7bf541b55b0d0a7d1214afa5c505463e5d4cb92.jpg',296346,23144,4522,368,1208,'BGM：莫西子诗 - 不要怕&啊杰咯');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1072081711,'“三斤的小猫，七斤的可爱！！”',1850119898,'http://i0.hdslb.com/bfs/archive/b2776da6f3fbd5e412873872c788057fb593df24.jpg',318990,14166,835,248,1346,'');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1072938807,'问题不大，终身监禁｜【海东老师】2023年3月27日直播',11083481,'http://i2.hdslb.com/bfs/archive/769f433e3f953afe344ca457daec0236b510ec00.jpg',784739,19531,1737,9421,2920,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1075984023,'泰坦尼克号头等舱二等舱和三等舱的食物都有什么不同？连餐具都差这么多？【叮叮猫不咬人】',1925825358,'http://i1.hdslb.com/bfs/archive/3f772e7d5d842257ed6290136cee5743dc1d696e.jpg',126832,7496,1598,759,187,'啊');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1069028813,'一个人去吃饭的路上，有棵树治好了我的孤独。',1474965865,'http://i1.hdslb.com/bfs/archive/6220339910ece848b0604d9904c07318018a719d.jpg',1107027,149872,12449,646,2989,'-');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1072886181,'IVE回归先行曲《Kitsch》MV',400667244,'http://i2.hdslb.com/bfs/archive/88cca839c2fd657290d3443689bba0103176b341.jpg',461015,16734,1366,1135,4670,'IVE');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1070912246,'服务器刚开服一周竟然就遭遇了毁灭式攻击！！！！',1076872109,'http://i0.hdslb.com/bfs/archive/ac93c0ee2a321129fd6ddfea8bc936e8b65e2400.jpg',757104,135902,29080,1075,269,'相信大家看完视频了，这两天修复真的费了我们不少精力\n",
      "视频结尾提到如何进入服务器 \n",
      "这里是🐧裙：740606046\n",
      "进裙后会有详细教程哦');\n",
      "insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (1076166115,'金钟仁&边伯贤&吴世勋《Rover》舞蹈Challenge！🐥🐻🐶',162151104,'http://i0.hdslb.com/bfs/archive/811c1908dbe64175c2719360f7d76a5553856035.jpg',140891,23290,1433,371,1794,'网络');\n"
     ]
    }
   ],
   "source": [
    "# bid_uniqe=[]\n",
    "# for i in range(len(uid)):\n",
    "#     #     剔除相同视频\n",
    "#     if (not bid[i] in bid_uniqe):\n",
    "#         bid_uniqe.append(bid[i])\n",
    "#         str_sql=\"insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (%s,'%s',%s,'%s',%s,%s,%s,%s,%s,'%s');\"\n",
    "#         print(str_sql%(video_data[i][0],video_data[i][1],video_data[i][2],video_data[i][3],video_data[i][4],video_data[i][5],video_data[i][6],video_data[i][7],video_data[i][8],video_data[i][9]))\n",
    "\n",
    "for i in range(len(uid)):\n",
    "    str_sql=\"insert into video (id,title,up,img,views,likes,coins,stars,shares,introduction) values (%s,'%s',%s,'%s',%s,%s,%s,%s,%s,'%s');\"\n",
    "    print(str_sql%(video_data[i][0],video_data[i][1],video_data[i][2],video_data[i][3],video_data[i][4],video_data[i][5],video_data[i][6],video_data[i][7],video_data[i][8],video_data[i][9]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
